It should. If you record a macro while saving the file as PDF you can see the code it creates, e.g.
ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _
        "C:\Users\Paul\Desktop\Book1.pdf", Quality:=xlQualityStandard, _
        IncludeDocProperties:=True, IgnorePrintAreas:=False, OpenAfterPublish:= _
        True
There are other options as well (saving only a selection as PDF, the entire workbook (all sheets) as PDF, etc.). Here's some info: http://msdn.microsoft.com/en-us/libr...ice.11%29.aspx

Also, your profile lists Excel 2003. Does that need to be updated? If so, click "My Profile" at the top of this page, then select the "About Me" tab in the profile. Click the small pencil next to My Microsoft Office Version.