Print 2 Excel sheets to same PDF File

[groundin]

Hi,
I need to print 2 excel sheets into the same PDF File (I use Primo PDF if that matters).
Currently the way it works is that it selects sheet then prints it, then call another macro and then selects that sheet and prints it.
But when it does that it is basically creating 2 separate PDF Files which I don't want.
Also I don't need to have the print dialog box come up twice.
Any Ideas?

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[6StringJazzer]

Try this, but I didn't create a file to test it. It would be easier to have yours.

Please Login or Register  to view this content.

[groundin]

Hi 6StringJazzer,
Thanks! I seem to be getting an error in

Please Login or Register  to view this content.

line when I try it.
My file is to large to upload

[6StringJazzer]

OK, this one was tested in a mock-up.

Please Login or Register  to view this content.

[groundin]

Thanks, Sorry about late reply, but works good!

[6StringJazzer]

This could also be exported directly to PDF natively in 2007+ without having to bring up the print dialog for the user and going through a third-party PDF writer. Do you need to go through the print dialog, or would you prefer to go direct to PDF?

[groundin]

Sure, what would that look like, may be easier...

[6StringJazzer]

Modify the code as shown. You will have to specify the location where you want it to be saved as shown. If you want to allow the user to specify anything they want then maybe the original version is your best bet.

Please Login or Register  to view this content.