S
Steph
Hi Ron,
I don't know if sending you a workbook will help. If I run the code
on 1 book, or 5 books, or 25 books the code works fine. It always
seems to die around the 35th book. I'm not sure if it's a size/memory
thing or not. I guess I can try to copy a buch of the 90Kb files, and
run the code on only those files to see how many books of 90Kb each
the code will chunk through.
Also, on a side note, the workaround that MS proposed I think will
work, but much slower. Apparently inserting a blank sheet and then
copying to it is ok. But copying (pressing ctl and dragging a sheet
to copy it) doesn't work past a certain point.
I'm also annoyed that MS said this problem was fixed post Excel 97!
Hi Steph
If you send me one of the workbooks I will test it for you also in
2003.
Is it always the same workbook where the macro stop?
I don't know if sending you a workbook will help. If I run the code
on 1 book, or 5 books, or 25 books the code works fine. It always
seems to die around the 35th book. I'm not sure if it's a size/memory
thing or not. I guess I can try to copy a buch of the 90Kb files, and
run the code on only those files to see how many books of 90Kb each
the code will chunk through.
Also, on a side note, the workaround that MS proposed I think will
work, but much slower. Apparently inserting a blank sheet and then
copying to it is ok. But copying (pressing ctl and dragging a sheet
to copy it) doesn't work past a certain point.
I'm also annoyed that MS said this problem was fixed post Excel 97!
Hi Steph
If you send me one of the workbooks I will test it for you also in
2003.
Is it always the same workbook where the macro stop?