Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy a worksheet from one file to another | Excel Discussion (Misc queries) | |||
Copy worksheet from one file to another | Excel Discussion (Misc queries) | |||
copy part of a worksheet into a worksheet in the same file/keepi. | Excel Worksheet Functions | |||
Copy File into Worksheet | Excel Programming | |||
copy a worksheet to another xls file | Excel Programming |