print using worksheet name from excel macro

About the programming interface for the virtual PDF printer driver.

Moderator: jr

print using worksheet name from excel macro

Postby netpilot » 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.
netpilot
 
Posts: 2
Joined: Tue Jun 23, 2009 8:31 am

Return to Programming

Who is online

Users browsing this forum: No registered users and 1 guest

cron