ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Corrupt PDF using MS Microsoft Save as PDF Add-in (https://www.excelbanter.com/excel-programming/427369-corrupt-pdf-using-ms-microsoft-save-pdf-add.html)

Tom Joseph

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




All times are GMT +1. The time now is 09:41 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com