how to skip open operation
 

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
--
thank you so much for your help

how to skip open operation
 

i'm using
DataImport External DataNew 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.


On Mar 25, 3:48*pm, clara wrote:
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
--
thank you so much for your help

how to skip open operation
 

Hi Clara,
Take a look to Ron web

http://www.rondebruin.nl/copy3.htm

"clara" wrote:

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
--
thank you so much for your help