Copying data without opening the workbook

  • Thread starter Thread starter Mayank Prakash Gupta
  • Start date 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
 
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.
 

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

Copy a worksheet to a new workbook 6
Excel macro code for copying data to a cell reference which is set byvalues in two separate cells in 3
Excel Protection 2
excel external data range "failed to refresh" 0
Macro to copy value in field and insert it into filter 2
VBA Macro - Copying specific data to different sheets in a workbookand linking the InputBox to a com 7
Copy value from changing cells without VBA 1
Why is my empty Excel workbook 2/3 MB in size? 6

Back
Top