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 |
opening workbooks faster
|
All times are GMT +1. The time now is 08:13 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com