Hi again,
Many thanks for your suggestion, which was very interesting. I have suggested an alternative approach which is easier for me to test, as I don't have access to your workbooks and don't know what sort of connections may be involved.
Take a look at the attached workbook and see if it does what you need. It uses the following code:
The highlighted values should be altered to suit your own requirements.
The process is broken down into several steps as follows:
a) create an array which contains the FullNames of each of the workbooks to be processed;
b) copy the values contained in that array to a column in the main (i.e. the attached) workbook;
c) read the first FullName in the above range and then open the Excel workbook with that name;
d) use the OnTime method to schedule the execution of a routine which prints the open workbook, closes the open workbook, reads the next FullName, and then repeats step c above;
e) exit and display a closing message when all of the FullNames have been processed.
Hope this helps - please let me know how you get on.
Regards,
Greg M
Bookmarks