New Forum | Previous | Next | (P-PDF) Developers
Topic: RE: Excel Workbook to PDF
Conf: (P-PDF) Developers, Msg: 57030
Date: 5/29/2002 05:23 PM
I don't know who told you that, but a good clip round the ear should help
there :) ..
I print Excel workbooks (with many Worksheets) all the time with no probs.
Do you have Acrobat 4.0 or Version 3? In Version 3 you had to make sure you
set your Print Area before you printed (in each worksheet), in Acrobat 4 and
PDFMaker 4 you don't need to set the print area, but if you have pages with
different orientations/sizes, _sometimes_ (and I stress sometimes, usually
because of pivotables and charts) you'll need to print them separately to
PDF as separate worksheets.
Otherwise, either use the PDFWriter and 'Print Workbook' or use the PDFMaker
macro to do the same thing.
Also remember that if you have to create multiple PDF files, you can use
Acrobat to 'Merge' these PDF's into one file (Insert Pages).
Got an AcroTip? let us know: mailto:email@example.com
AcroBuddies Forum Moderator
> I would like to convert an excel workbook into PDF. The workbook has 10
> sheets and 3 of the sheets are more than one page long.
> I was told that the since the sheets exist of multiple pages that this can
> not be converted correctly.
> If true how do you overcome this?
> If false what is the proper procedure?