print using worksheet name from excel macro
Posted: Tue Jun 23, 2009 9:36 pm
First post.
I have a 3 sheet Excel spreadsheet and would like to print each worksheet to a separate pdf file from within a macro, using the worksheet name as the pdf output file name in each case i.e. sheet1.pdf, sheet2.pdf, sheet3.pdf. Thanks for any ideas, as I've failed with everything I've tried so far.
I have a 3 sheet Excel spreadsheet and would like to print each worksheet to a separate pdf file from within a macro, using the worksheet name as the pdf output file name in each case i.e. sheet1.pdf, sheet2.pdf, sheet3.pdf. Thanks for any ideas, as I've failed with everything I've tried so far.