Print complete excel workbook with command line arguments

PDFCreator PDFCreator English
1

Hi!

 

I'm trying to automate the process of printing a complete workbook in excel 2010 with pdf creator. I've tested the command line arguments and I can create a script that saves the file, but I only get the active sheet.

Is there some way to print the whole workbook? 

2

Hello,
i just want to know if you've found a solution to generate a PDF file from a excel workbook with PDFCreator commandline.
Thank you.
Norman

3

Hi,

 

please try disabling "Allow special Ghostscript chars in filename" in options->save.

 

regards,

 

Robin

4

 Robin

I tried disabling that setting but it didn't make any difference. I am printing using the API though and just changed the settings from the PDFCreator UI.

5

Hi,

 

in Excels printing settings, you need to set "print the entire workbook" instead of "only print the active sheets".

 

regards,

 

Robin