Importing data from multiple worksheets

Sissyfoo

New Member
Joined
Oct 7, 2005
Messages
26
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
 

Some videos you may like

Excel Facts

Select all contiguous cells
Pressing Ctrl+* (asterisk) will select the "current region" - all contiguous cells in all directions.

Watch MrExcel Video

Forum statistics

Threads
1,118,029
Messages
5,569,747
Members
412,289
Latest member
Kingchaos64
Top