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.
Ron de Bruin