Hi,
The code I have listed below is used to create a new .xls sheet where their is a new page break (which have all come from a subtotal function) but I would prefer to modify so that:

1. The output file is a pdf and,
2. The pdf is rotated to be landscape.

Please Login or Register  to view this content.
I've tried adding ".pdf" at the end of the "SaveAs" line and this creates a pdf file which can't be opened and is shown as corrupted.

Would greatly appreciate any assistance.

Cheers

http://www.excelforum.com/images/icons/icon7.png