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?
i just want to know if you've found a solution to generate a PDF file from a excel workbook with PDFCreator commandline.
please try disabling "Allow special Ghostscript chars in filename" in options->save.
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.
in Excels printing settings, you need to set "print the entire workbook" instead of "only print the active sheets".