Select All Sheets & Save as PDF

[eoinymc]

Hi,

I was wondering if anyone has a way of selecting all sheets and saving all of them as a PDF using VBA?

Or is there just a way to save the entire workbook as a PDF using VBA?

Cheers,

E

 

[Domenic]

If your using Excel 2007 or later, you can use the ExportAsFixedFormat method of the Workbook object...

 

[eoinymc]

Thanks Domenic!