Hi all
Excel 2007 B2TR and the final version will not have SaveAs PDF by Default.
You must install a MS ADD-in if you want to have this option in Office.
I am really glad the MS have added this in Excel 2007.
The 2007 version of my SendMail add-in will have this option also.
On this page there are a few vba examples and the link to the add-in so you can try it.
http://www.rondebruin.nl/pdf.htm
Have fun
Ron de Bruin
http://www.rondebruin.nl/tips.htm
Maybe it’s better to use anouther application instead of add-on?
Convert PDF to Excel