VBA to create pdf thats 2007 compatable

[tonywatsonhelp]

Hi Everyone,

I need a macro to create a pdf of active sheet
but it needs to work on 2007 version as well anyone remember the code to do this?

please help if you can

Thanks

Tony

 

[DanteAmor]

Try this
I have excel 2007.

Sub Macro7()
  ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:=ThisWorkbook.Path & "\" & "FileName.pdf", _
    Quality:=xlQualityStandard, IncludeDocProperties:=True, IgnorePrintAreas:=False, _
    OpenAfterPublish:=False
End Sub