Macro to automate printing
Posted by Dwight on September 20, 2001 5:27 AM
I work with 50+ spreadsheets which periodically must be printed; a tedious task. The spreadheets are identically structured and grouped within 7 directories. I would like a macro which, when one of the spreadsheets is open, will select all of the worksheets in that spreadsheet (each has 6 sheets), print them to the default printer, and close the file without saving. I would appreciate any thoughts on this or if there would be ways to automate the process even more ( a macro which would print all of the sheets for all spreadsheets within a given directory?).