ExportAsFixedFormat for Multiple Sheets in a Single Excel File

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ivanL - 12 Feb 2008 18:05 GMT

It seems I can only save to PDF one sheet at a time, is it possible to print
multiple sheets in a single PDF document i.e. multiple page PDF?

Thanks.

Reply to this Message

Gord Dibben - 12 Feb 2008 18:58 GMT

There are several programs that will allow you to print to pdf with multiple
sheets.

PrimoPDF is one of them.

http://www.primopdf.com/

You install and it shows up as a printer in Excel.

In addition, I have had success with the free file downloads and instructions
for use here at Dale Nurden's site.

http://www.rcis.co.za/dale/info/pdfguide.htm

Saves first to single *.ps file which is then converted to *.pdf

Returns one PDF file from multiple sheets.

Gord Dibben MS Excel MVP

>It seems I can only save to PDF one sheet at a time, is it possible to print
>multiple sheets in a single PDF document i.e. multiple page PDF?
>
>Thanks.

Reply to this Message

Ron de Bruin - 12 Feb 2008 19:42 GMT