Re: $$Excel-Macros$$ Run-time error '424' : Object required (ActiveSheet.ExportAsFixedFormat)

Thanks a lot! Works perfectly! -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don

Re: $$Excel-Macros$$ Trying to ExportAsFixedFormat - getting error "expected end of statement"

Hi! Thanks! I'm actually on Mac Office 2011 and it has a save as PDF option. That might be it, but I can't find a plug-in for mac... -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Form

$$Excel-Macros$$ Run-time error '424' : Object required (ActiveSheet.ExportAsFixedFormat)

I'm getting a run-time error '424': Object required for the following code: Sub ExportPDF() Sheets("OOF2_EIF").Activate ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:=“sales.pdf”, Quality:=xlQualityStandard, OpenAfterPublish:=True End Sub Help would be greatly app