Print to PDF

[Ronbo]

I need to create code that will print a 50 page report to Acrobat PDF. If I
manually click on "Adobe PDF" - "Convert to Adobe PDF" with the "Convert
Entire Workbook" checked... it works perfect! But using the following code
it will only print one page;

ActiveWorkbook.PrintOut Copies:=1, ActivePrinter:= _
"Adobe PDF on Ne02:", Collate:=True

If I create a new workbook, the above code works perfect. I have tried to
isolate the problem by creating the problem in a new workbook by changing
layout, margins, fit to one page etc. but no matter what I do it still works
perfectly.

I have tried to strip just about everything out of my workbook, down to 2
pages with a little text on each and it still does not work. I copied these
two page to a new workbook and it would not work.

I have looked and looked and not found a reason why it is doing this or a
solution. If anyone can help it would truely be appreciated.

I am using Excel 2000, Acrobat 7.0 Pro and XP Pro.

Regards,
Ronbo

 

[Nigel]

Check the print setting for each sheet. One issue I have faced is that the
resolution is different on different sheets.

 

[Ronbo]

Nigel -

Thanks a lot!!! They were differant and after setting all to 1200dpi it
worked perfect.

Again, Thanks
Ronbo