Copying an Excel sheet from a closed xls document into the current doc

[VBAguy22]

Hi there,
Using VBA i need to be able to copy a sheet, called CopyMe, from a closed document, say C:\Source.xls, into the current document (the open document) say C:\Target.xls.
I assume I will have to open source.xls in the background or something to that extend. If you got any code cuts they would be greatly appreciated!

Alex

 

[SkipVought]

Hi,

take a look at MS Query via menu item Data/Get External Data/New Database Query -- Excel Files -- C:\Source.xls -- THE WORKSHEET in C:\Source.xls.....

Skip,

_{[red]A palindrome gone wrong?[/red]
A man, a plan, a ROOT canal...
PULLEMALL!}

 

[VBAguy22]

My sheet is not really a table so the query doesnt find it. I just need a way to say "Pick up SheetX from C:\Source.xls, make a copy of it into C:\Target.xls

 

[SkipVought]

wbSource.WhatSheet.Cells.Copy Activesheet.[A1]

Skip,

_{[red]A palindrome gone wrong?[/red]
A man, a plan, a ROOT canal...
PULLEMALL!}