PrintToFile in word and excel

[jameslast]

Hello,

If I use office (word/excel) automation to print a file with the amyuni pdf converter to an PDF file I wonder if I have to set the printtofile=true in the printout method or not?

I noticed, if I do not set it in excel, there is only one sheet printed (using application.sheets.printout), if I set printtofile=true every worksheet is in the PDF.

Are there any drawbacks in using the printtofile?

Thank you!

Regards,
James

[Joan]

Hello,

The print to file is not needed to convert documents to PDF.

For Excel by default it prints the 'Active Worksheets', you need to set it to print 'Entire Workbook'.

Hope this helps.

[jameslast]

Hello Joan,

thats where my problem comes in.
If i select "Entire Workbook" the vb code looks like sheets.printout instead of activesheet.printout.

If I do so, every sheet wants to be printed into a seperate print job.
I tested this with the "Microsoft Office Dokument Image Writer". It wants to print into separate files.

BUT, if i set the printtofile option to true it works fine.
-> BUT if I do so, i cannot print on x64 based systems anymore with amyuni.

I hope I do not have to choose between onle one sheet printed or x64 support.

Thank you!

[Joan]

Hello,

You can use sheets.printout and add 'Concatenate' to your call of FileNameOptions.

You will get all the sheets in one PDF file.

Hope this helps.