Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Default save as location in Microsoft Query | Excel Discussion (Misc queries) | |||
Save as file format excel worksheet 4.0 in Microsoft excel 2007 | Excel Discussion (Misc queries) | |||
microsoft excel 97 toolbars won't save settings | Excel Discussion (Misc queries) | |||
microsoft query in excel default save path | Excel Discussion (Misc queries) | |||
how do you auto save in Microsoft Excel? | Setting up and Configuration of Excel |