I have a workbook with several worksheets. I have a macro
that prints all print areas within each worksheet all at
once. I would like to print all of the worksheets to one
Adobe file. How do I do this. I have Adobe Arcobat 6.0.
When I execute my macro, it wants to print to individual
files instead of appending each worksheet to one file.

John

John

I realize you already have AA 6.0 and probably don't want to use another
method but...

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 or selected sheet.

Adobe Acrobat has trouble with multiple sheets. From what I hear, AA saves a
separate file for each sheet.

Have you tried selecting all worksheets before sending to the print-to-file
via Adobe?

Don't know if that works any better.


Gord Dibben Excel MVP



On Thu, 31 Mar 2005 09:25:20 -0800, "John Day"
wrote:

I have a workbook with several worksheets. I have a macro
that prints all print areas within each worksheet all at
once. I would like to print all of the worksheets to one
Adobe file. How do I do this. I have Adobe Arcobat 6.0.
When I execute my macro, it wants to print to individual
files instead of appending each worksheet to one file.

John

Similar question - can I write a macro to save the file to PDF using a
specific cell as the file name ?

"Gord Dibben" wrote:

John

I realize you already have AA 6.0 and probably don't want to use another
method but...

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 or selected sheet.

Adobe Acrobat has trouble with multiple sheets. From what I hear, AA saves a
separate file for each sheet.

Have you tried selecting all worksheets before sending to the print-to-file
via Adobe?

Don't know if that works any better.


Gord Dibben Excel MVP



On Thu, 31 Mar 2005 09:25:20 -0800, "John Day"
wrote:

I have a workbook with several worksheets. I have a macro
that prints all print areas within each worksheet all at
once. I would like to print all of the worksheets to one
Adobe file. How do I do this. I have Adobe Arcobat 6.0.
When I execute my macro, it wants to print to individual
files instead of appending each worksheet to one file.

John