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