First post.
Can anybody please explain how to print to pdf from within an Excel macro, using the worksheet name and original file path as output.
Thanks for any suggestions.
Search found 2 matches
- Thu Jun 25, 2009 1:54 pm
- Forum: Programming
- Topic: Print pdf to sheet name in excel macro
- Replies: 0
- Views: 16894
- Tue Jun 23, 2009 9:36 pm
- Forum: Programming
- Topic: print using worksheet name from excel macro
- Replies: 0
- Views: 11349
print using worksheet name from excel macro
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...