I have built a model in Excel 2010 but have to accommodate 2003 users... My code generally works but I'm getting a run-time error 438 (object doesn't support this property or method) when I run the following in 2003.:
ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, FileName:=FileNamePDFcatch, _
Quality:=xlQualityStandard, IncludeDocProperties:=False, _
I assume it's because the syntax required to create the pdf has changed between 2003 & 2010.
Can anyone help me get the 2003 syntax?
I'm hoping that would still work in 2010...