A customer asked me if it was possible to convert an Excel workbook with multiple worksheets into individual PDF documents, each named by the worksheet tab.
Well… it is… and here’s how:
1. Select Create PDF and in the Acrobat PDFMaker dialog box select all worksheets
2. Open the resulting file and notice there are now bookmarks that match the worksheet names
3. Select Document > Split Document.
a.Select Top-level bookmarks; select Output Options
b. Select Use bookmark names for file names
And now with just 2 actions (Create PDF & Split Document), you have your individual files.