Importing data from multiple worksheets

[Sissyfoo]

Hello again.

I'm building a master report sheet and everything seems to be working fine (for a change). Currently the master report calls a macro when opened that opens 5 workbooks in the folder below it and imports data from the textboxes within and then closes the workbooks without saving them. The problem that I am having is that each of these workbooks are about 1.3mb in size and opening all 5, importing the data and then closing them again is taking up a fair bit of time (~40 seconds). I am using the application.screenupdating = false to speed things up a bit but it is still taking a fair bit of time and as I haven't even finished coding in the rest of the updating I a bit worried that by the time the uber-director has actually managed to open his master report humanity will be extinct and the ants will have taken over. Is there a way to speed things up a bit? Would it be better if I tried to import the data without actually opening the workbooks?

Any tips would be greatly appreciated.

Ta,

James

 

[BrianB]

1. Setting calculation to xlManual saves lots of time.
2. You say you are opening all workbooks at the same time (?) - one at a time has less memory usage.
3. Using files from a server rather than local hard drive is slower.
4. 1.3mb is not a large file. This runs reasonably well & might help :-

http://www.mrexcel.com/board2/viewtopic.php?t=145246&highlight=

 

[Sissyfoo]

Cool! Thanks for the tips. I'll have a look and see if I can utilise them.