T
Tom Joseph
I have an Excel app that saves PDFs. The code has always worked on my
machine, but on another machine, it generates small corrupt pdfs.
Anyone else have experience with this?
Here is the code.
FilenameStr = Application.DefaultFilePath & "\" & _
Format(Sheets("Main").Range("AB5").Value, "yyyymmdd") _
& "_" & Worksheets("eMail").Cells(4, i).Value _
& ".pdf"
Sheets("Report").Select
ActiveSheet.ExportAsFixedFormat _
Type:=xlTypePDF, _
Filename:=FilenameStr, _
Quality:=xlQualityMinimum, _
IncludeDocProperties:=True, _
IgnorePrintAreas:=False, _
OpenAfterPublish:=False
machine, but on another machine, it generates small corrupt pdfs.
Anyone else have experience with this?
Here is the code.
FilenameStr = Application.DefaultFilePath & "\" & _
Format(Sheets("Main").Range("AB5").Value, "yyyymmdd") _
& "_" & Worksheets("eMail").Cells(4, i).Value _
& ".pdf"
Sheets("Report").Select
ActiveSheet.ExportAsFixedFormat _
Type:=xlTypePDF, _
Filename:=FilenameStr, _
Quality:=xlQualityMinimum, _
IncludeDocProperties:=True, _
IgnorePrintAreas:=False, _
OpenAfterPublish:=False