Merckling
04-07-2017, 05:45 AM
Hi everyone, new to the forums, as well as VBA. Trying to fix a Run-time error '1004' when I attempt to generate a report in Excel.
After the error, clicking debug highlights this line of code:
ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:=strPDFFileName
Is there an obvious mistake I'm making here or will I need to include some more information?
Appreciate the help.
After the error, clicking debug highlights this line of code:
ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:=strPDFFileName
Is there an obvious mistake I'm making here or will I need to include some more information?
Appreciate the help.