Printing Excel using Acrobat Adobe

[JeffH]

I would like to print all the active worksheets in one PDF file. When I try
to print all the active worksheets, it will print a number of them in one PDF
file, then prompt me to name it, print another worksheet and prompt me, etc.
I don't understand why it will print a number (say 5 or 6) active worksheets
in one PDF file and then print only one (1) in the following. I print 40
active worksheets and it will create approximately 7 different PDF files.

 

[DDEAN]

Just came across this same problem this morning. I have 45 sheets I want
printed to a PDF, it'll ask me a name to save the file under and then will
print 40 pages in that file. Then it will prompt me for a new file name and
will print 1 page and then again for the remaining 4 pages. No clue as to
why....any one ever hear of this?

 

[Jock]

Hi
I have been trying to do some thing along the same lines.
have a look here:
http://www.lebans.com/reporttopdf.htm

Also search Win2PDF as an alternative.

Regards,