Legal
The views expressed in this blog are my own and do not necessarily reflect the views of Adobe Systems Incorporated.
Search
April
| S | M | T | W | T | F | S |
|---|---|---|---|---|---|---|
| 1 | 2 | 3 | 4 | |||
| 5 | 6 | 7 | 8 | 9 | 10 | 11 |
| 12 | 13 | 14 | 15 | 16 | 17 | 18 |
| 19 | 20 | 21 | 22 | 23 | 24 | 25 |
| 26 | 27 | 28 | 29 | 30 |
Archives
- October 2009
- September 2009
- August 2009
- June 2009
- May 2009
- April 2009
- March 2009
- February 2009
- January 2009
- December 2008
- November 2008
- August 2008
- July 2008
- June 2008
- November 2007
- October 2007
- September 2007
- July 2007
- June 2007
- April 2007
- March 2007
- February 2007
- January 2007
- November 2006
- October 2006
- September 2006
- August 2006
- May 2006
- April 2006
- March 2006
- February 2006
- December 2005
- October 2005
- September 2005
- August 2005
- January 1970
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
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.