| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to open many excel files efficiently
Hi,
I tried opening 50+ files using the Open method at theWorkbook class at one go. However due to the size of each file, which average about 2 MB, the process takes too long to open. Is there a more efficient way to open these files? Because each file takes about 5 mins to process and open. I have tried opening a file, process it and closing it. But it doesn't make any difference. Is there a way to open 1 excel process and use that process to open the rest of the excel files? That should be the best way to open and process them right? Regards xs |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| emailing files from excel, the files will not go until I open up . | New Users to Excel | |||
| how do I toggle between 2 open excel files and leave both open | Excel Discussion (Misc queries) | |||
| How to change default Open/Files of Type to "Microsoft Excel Files | Excel Discussion (Misc queries) | |||
| I cant open files unless I open the Excel program first | Excel Discussion (Misc queries) | |||
| Can not open excel files without open application | Excel Discussion (Misc queries) | |||
Threaded Mode
