LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default Using ExportAsFixedFormat

Hi there,

I am banging my head trying to use: ExportAsFixedFormat.
I am using Excel 2007, with PDF export, everything works fine doing
it by hand. All I am trying is:
- open the xls file (1997 format)
- add some charts
- export to pdf

But I get this funky error saying that my file is not saved. If I try
then to save it as .xls file, my charts become green (don't ask). And
if I try to save it as ".xlsx" I cannot reopen the file, Excel tells
me that the file is not recognize:

....
wb.SaveAs( fullpath ) # how do I specify I want the new .xslx format ?
wb.Close( )

# reopen to please Excel about "unsaved workbook"
wb = xl.Workbooks.Open( fullpath )
ws = wb.Worksheets(1)

ws.ExportAsFixedFormat(Type=constants.xlTypePDF,
Filename=fullpath_pdf, Quality=constants.xlQualityStandard,
IncludeDocProperties=True, IgnorePrintAreas=False,
OpenAfterPublish=False)
....

Thanks !
 
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
ExportAsFixedFormat printing issue Ramon Busboom Excel Programming 0 April 14th 08 05:13 AM
ExportAsFixedFormat? Robby Excel Programming 3 February 27th 08 09:23 AM
ExportAsFixedFormat for Multiple Sheets in a Single Excel File ivanL Excel Worksheet Functions 2 February 12th 08 07:42 PM
ExportAsFixedFormat Options Robby Excel Programming 0 July 12th 07 05:36 PM
Problem with ExportAsFixedFormat in Excel 2007 Robert Simpson Excel Programming 9 June 19th 07 11:36 AM


All times are GMT +1. The time now is 02:10 PM.

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

About Us

"It's about Microsoft Excel"