Copying data without opening the workbook

  • Thread starter Mayank Prakash Gupta
  • Start date
M

Mayank Prakash Gupta

Hi All,

Is there a way in which I can copy data from some named ranges in a excel
workbook without actually opening it. I have to do it through VBA. The idea
is to get the data from a file into the file which is running the VBA code.

Please help, its very urgent.

TIA
Mayank
 
D

Dave Peterson

Why not just open the file, retrieve the data and close the file.

If you use
application.screenupdating = false
'your code to retrieve the data
application.screenupdating = true

the user won't even know how it worked.
 
Top