how to skip open operation

C

clara

Hi all,

I am consolidate multiple xls files into one, now in code, I have to use
workbooks.open(...) first, then do retrieve, but this method is too slow. Is
there any way retrieve data from a xls file without opening it.

Clara
 
A

AB

i'm using
Data>Import External Data>New Database Query
extensively.
In vba it would be something like:
activesheet.querytables.add...

If the .xls file is huge, though, it'll be opening it up anyway.
 

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

Open file from path in cell and open from current file path 0
Remove end folder from path found with ThisWorkbook.Path command ? 9
Copy Data from Closed File to Existing File 0
Test if Workbook is already open ? 2
Oddity when opening templates from code 2
File opens another file runs macro and closes 2
Use external file variable in formula 2
Error Opening Workbook 3

Top