I have a folder which contains 20 excel files. Each file contains registration data for pupils. One work sheet.
I want a script that will run through the folder and print each file out to the default printer. It would be even better if they could select a specific printer from their list as they might not always want to use the default.
I am hoping somebody has a similar script thay could share.
The computer is windows 7 PRO and they use Office 2007/2010
It would also be useful if a log file could be created saying what file was printed and when.