Learn how to Work Smarter

Thursday, November 19, 2009

Automated PDF creation

Recently had a set of Excel charts (hydrographs) to print to one PDF, found it more challenging than I thought.

I had exported a water elevation query (~8,500 records) to Excel that looked like this:



...then macro'd new charts based on changes in row data, and - like magic - created 60+ line scatterplots.  Whee!  Thinking back, I'd do this differently next time.  But "it's consulting" so it's time to keep the head down and finish the job...

This is where I learned that selecting simply trying to print the entire workbook to PDF creates, unfortunately, as separate PDFs as you had charts!  (Not to mention the data.)  Sigh.

Enter google and this article: Using VBA for Excel and PDFCreator to print multiple pages to ONE pdf.
http://www.excelguru.ca/node/21

No comments:

Post a Comment

Home | My Schedule (Free/Busy) | Professional CV | Learn how to Work Smarter

A Little More Background

Friends & Followers