You could try the standard things like turning of screen updating, calculation and events.
Another thing that might help is getting rid of this in the first sub.
I don't really think you need to go back to the workbook the code is in, you already have the filenames for the files to open in the array.
That should speed things up a bit, we'd probably need to see sample workbook(s) to tell if there's anything that could make a significant impact.
PS You should probably be using FormulaR1C1 as all your formulas are in R1C1 notation, never kno that might speed things up a bit too.
Bookmarks