Hello,
Thanks for the reply, I have a folder that has 52 excel file I open them all
and get certain fields form them and write to a single file.
So here is what I need to do then:
1. Loop through the files c:\Reports\*_YYYYMM_*_0_*.xls and copy their
contents to a single file and single sheet. Their contents are identical such
as A1=ID, B1=Name, C1=Amount
2. Sheet1 would have ID, Name, Amount at the end of the process above. Loop
though the Sheet1 and sum Amount per ID and create a new sheet Sheet2 that
has ID, Name, TotalAmount.

How can I do this?


"Dave O" wrote:

The answer to that question may be a function of the amount of memory
on your computer. If I may be so bold: why do you need 30 files open
at once? Perhaps if you'll explain your process we can suggest a
workaround that would not require so many open files.