Printing Multiple Excel worksheets in one PDF file

[khschenk]

hello:

We have a macro that prints from multiple worksheets in an Excel workbook. The problem is that I am trying to create one PDF file from the worksheets. When this runs, Excel wants to create a separate PDF file for each worksheet. Any suggestions would be helpful.

Thanks.
--Kurt

 

[111011]

I don't know of any way to create one file from excel but if the end result you want is just one file and you don't mind creating several files and adding them together I would sugest getting acrobat writer. after creating all your pdf files you can combine them using acrobat writer by inserting the pages.