Automate PDF creation of multiple Excel files

[Mario P.]

Hi, does anyone know how to go about generating in one swoop PDFs of
many Excel files at once, each with several spreadsheets. I have tried to use
Applescript and Macros, but run into the problem that the program in
creating a PDF, even if it is told to include all the pages, tends to include
only one, perhaps because it is creating multiple files and savinf them by the
same name. Coming up with a solution to this would save a lot of time and
any ideas would be much appreciated.

Mario

 

[Richard Nichols]

I have been looking for the same solution...unfortunately, this is all I
have found to date...

The "Read Me" file that comes with Adobe Acrobat Professional v6.02 says the
following:
"Creating Adobe PDF from Excel:
The Adobe PDF printer and PDFMaker for Macintosh do not support the printing
of entire Excel workbooks. To accomplish this, convert each spreadsheet to
Adobe PDF individually. Then use the Create PDF From Multiple Files option
in the File menu to combine them into one PDF file."

Let me know if you find the solution!
Richard

 

[Jim Gordon MVP]

Hi Richard,

A Macro could do the work for you.

The macro would need to activate one sheet at a time and then activate
the Adobe button from the toolbar.

Are you up to writing the macro? It might be fun.

-Jim

--
Jim Gordon
Mac MVP
MVP FAQ
<http://mvp.support.microsoft.com/default.aspx?scid=fh;EN-US;mvpfaqs>

 

[Richard Nichols]

Thanks for the suggestion Jim,

Having not done this before, I'm not sure where to start. Any suggestions
would be appreciated...

-Richard