| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Change cut/paste operation to cut/insert operation | Excel Programming | |||
| How to skip files which are open? | Excel Programming | |||
| Open files, skip a folder | Excel Programming | |||
| Open files in folder - skip if already open | Excel Programming | |||
Linear Mode
