Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Default save as location in Microsoft Query ngg Excel Discussion (Misc queries) 0 August 8th 08 08:43 PM
Save as file format excel worksheet 4.0 in Microsoft excel 2007 Saria Excel Discussion (Misc queries) 1 July 14th 08 11:39 AM
microsoft excel 97 toolbars won't save settings [email protected] Excel Discussion (Misc queries) 1 January 26th 07 03:31 PM
microsoft query in excel default save path George Applegate Excel Discussion (Misc queries) 0 January 2nd 07 11:06 PM
how do you auto save in Microsoft Excel? kevinsraeofsunshine Setting up and Configuration of Excel 1 April 8th 05 09:23 PM


All times are GMT +1. The time now is 04:59 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"