View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tom Joseph Tom Joseph is offline
external usenet poster
 
Posts: 51
Default Corrupt PDF using MS Microsoft Save as PDF Add-in

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