Converting Excel 2011 files to PDF via macro or some other automated method

Question

Level 1

0 points

Converting Excel 2011 files to PDF via macro or some other automated method

Greetings,

I have around 300 music charts in Excel that I need to convert to PDF. Office 2011 for the Mac does this fine using the "Save As" feature, but I'm afraid I do not have the patience to do this 300 times. Is anyone aware of an easier, perhaps automated method and/or piece of software that will do this conversion with less pain?

Thanks.

Bob

Macbook, Mac OS X (10.6.5)

Posted on Nov 27, 2010 2:22 PM

Reply

Answer 1

Bob Ess Author

Level 1

0 points

Nov 27, 2010 4:22 PM in response to Bob Ess

Turns out to be quite simple via Automator. Using the workflow feature (and the Unix command line to hoard all of the pdfs into one directory), Automator did the dirty work in under three minutes.

Reply

Answer 2

Feb 21, 2011 7:52 AM in response to Bob Ess

I know this is back in 2005, but do you know what code you used for Automator?

Reply

Answer 3

jasustar

Level 1

0 points

Jun 13, 2011 12:41 PM in response to Bob Ess

There is a much easier solution if you have Adobe Acrobat Pro insatlled. Simply launch Acrobat Pro then go to the Advanced menu and choose Document Processing --> Batch Processing. Choose create PDF and point Acrobat Pro to the folder holding your 300 Excel files. No scripting needed.

Reply