merge multiple Workbooks to master workbook performance optimization

Hi,

Unfortunately I'm forced (at work) to use excel2000 with a system of macros which is slow as hell and I'm trying to improve things, even though I'm kinda new to VBA macros.

The Structure is this:

-2 Folder "Sales" "purchase" both folder have 10-30 excel files with all the same structure, 3 working sheets with a lot of data, the structure of all the files is identical (in both directories)
-The main workbook opens all the files it finds in the directories "purchase" and "sales" sums it up and adds it to a some worksheets.


My readout approach with pseudo code

Please Login or Register  to view this content.

my file opening pseudo code:

Please Login or Register  to view this content.

Any Idea to speed this process up? I though about merging all the different xls files for each directory in one "helper workbook", because it seems the limiting factors is to open/close all the files and check with some checksums if the files were modified or new files added to the directories and open the new files and add it to the main workbook sheets instead of open and close everytime every file eventhough nothing has changed.

thoughts? is my problem clear?

thanks

Here's some code that I use

Please Login or Register  to view this content.