I have several (okay, about 500) different sheets to open, extract data, drop
it into another workbook, and close.
I've tried simply using references to the workbooks in the cells. Problem is
a) takes WAY too long to update and
b) those 500 files come out at about 31 per month - that is, in January,
there are 31 files, February, another 31 files.
I want to drop the data in each month to minimize the refresh time.
BUT, the sheets (the data entry sheets) are very complex and have
Workbook_Open and _Close and Sheet_Deactivate macros that I want to prevent
from firing when the data is downloaded. Mostly just so I can speed things up.
Any ideas?
Thanks all.
Bookmarks