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
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