Copy Worksheet from another file
 

I need help in being able to copy a worksheet from another file and insert
the copy into my currently opened workbook using VBA. The source file is
located on a network drive (LAN). Can this be done without actually opening
the source file?

Copy Worksheet from another file
 

Steve
No. The source file must be open. You can prevent anything on the
screen from changing while the code opens the other file and does the
copying and closing of the other file, but it has to be open for the code to
copy from it. HTH Otto
"Steve" wrote in message
...
I need help in being able to copy a worksheet from another file and insert
the copy into my currently opened workbook using VBA. The source file is
located on a network drive (LAN). Can this be done without actually
opening
the source file?

Copy Worksheet from another file
 

Thnx Otto

"Otto Moehrbach" wrote:

Steve
No. The source file must be open. You can prevent anything on the
screen from changing while the code opens the other file and does the
copying and closing of the other file, but it has to be open for the code to
copy from it. HTH Otto
"Steve" wrote in message
...
I need help in being able to copy a worksheet from another file and insert
the copy into my currently opened workbook using VBA. The source file is
located on a network drive (LAN). Can this be done without actually
opening
the source file?