Corrupt PDF using MS Microsoft Save as PDF Add-in

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

PDF the Excel Report 3
Macro to Publish as PDF 1
Print to PDF 1
Looping and pdf-making 4
Mail Multiple Sheets via PDF Q 5
Converting an Excel file to PDF Q 1
PDF export add-in 2
Sending PDF with Outlook 1

Top