Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
opening workbooks faster
I have a program which opens a number of workbooks, one by one, extracts
data from them and copies the data to another workbook where I work on it. Once the data are extracted, the workbook which contains the data is closed. The whole process works well but opening and closing the workbooks takes twice as much time as processing the data. I am using Workbooks.Open filename:= ActiveWorkbook.Close savechanges:=False to open and close the workbooks. Are there any faster alternatives to this? Can I extract the data to memory from the workbook without opening it then copy it to the "working" workbook? If so, would this be any faster? Any comments gratefully received Thanks Chris |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
opening workbooks faster
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Opening new workbooks | Excel Discussion (Misc queries) | |||
Sharing Workbooks faster than 5 min | Excel Discussion (Misc queries) | |||
Opening workbooks | Excel Discussion (Misc queries) | |||
Can faster CPU+larger/faster RAM significantly speed up recalulati | Excel Discussion (Misc queries) | |||
What's faster? 1 workbook or multiple workbooks? | Excel Worksheet Functions |