Hi all,
I was wondering what the forum's thoughts were on the most efficient way to loop over a large set of workbooks where ordering matters (i.e., possibly you need to copy data from workbookx, then workbooky and then workbookz in exactly that order and pasting all this data to a single workbook) and where the data in the workbooks may be so large that you would prefer (or might even be unable) to have all the workbooks open at the same time.
In the past I have dealt with the first issue by using the workbooks(i) format and opening the workbooks in such a way that the ordering was correct. I then looped over these workbooks using a do while loop. So any thoughts on better methods would be appreciated.
I have never dealt w/ the second issue though. I have just wondered how one would accomplish this efficiently. In particular whether there was any way to loop over a large number of closed workbooks w/o having to specify each workbook's exact name i.e., "c:/book1.xls", "c:/book2.xls" and so on.
Thanks,
JK
I was wondering what the forum's thoughts were on the most efficient way to loop over a large set of workbooks where ordering matters (i.e., possibly you need to copy data from workbookx, then workbooky and then workbookz in exactly that order and pasting all this data to a single workbook) and where the data in the workbooks may be so large that you would prefer (or might even be unable) to have all the workbooks open at the same time.
In the past I have dealt with the first issue by using the workbooks(i) format and opening the workbooks in such a way that the ordering was correct. I then looped over these workbooks using a do while loop. So any thoughts on better methods would be appreciated.
I have never dealt w/ the second issue though. I have just wondered how one would accomplish this efficiently. In particular whether there was any way to loop over a large number of closed workbooks w/o having to specify each workbook's exact name i.e., "c:/book1.xls", "c:/book2.xls" and so on.
Thanks,
JK