Copy Worksheet from another file

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 
Thnx Otto

Otto Moehrbach said:
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
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Copying cells and formula from closed workbook to all sheets in open workbook 0
Copying Worksheets 1
Import selected worksheet from another workbook 1
Copy Worksheet 3
Prevent Copying of Excel Workbooks in 2000 and 2003. 2
non basic code in call stack 3
Copying worksheet from hidden instance of Excel 1

Back
Top