Printing multiple sheets to individual pdf files simultaneously?

**rbethe** · 09-17-2013, 02:37 PM

I have Excel 2010 and Adobe Reader 10.0. I have a workbook with 70 tabs that I need to print to individual pdf files named the same as the tab name. How can I do that?

**Dimitrov** · 09-18-2013, 10:30 PM

Paste this code into a module and run it.

Please Login or Register  to view this content.

Hope this helps.
_____________________________
[1] If this reply was helpful, click the star to the left.
[2] If this reply answered your question, mark this thread as [SOLVED].

**whitehea** · 04-02-2015, 06:45 AM

This is fantastic - worked first time - just saves them all into the directory.

however in addition I want it to then attach each pdf into an email with some standard text in the body of the email and standard subject (but sent to different people) how would i do this please would i need a separate module of code or could it be added to this one.

I then am trying to create a button to run this on click....?