Recently Approved

Archive for April, 2009

April 25, 2009

TIP: Converting Excel to Adobe PDF Options

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

split01.jpg

2. Open the resulting file and notice there are now bookmarks that match the worksheet names

split02.jpg

3. Select Document > Split Document.

a.Select Top-level bookmarks; select Output Options

split03.jpg

b. Select Use bookmark names for file names

split04.jpg

And now with just 2 actions (Create PDF & Split Document), you have your individual files.

11:53 PM Permalink