|Excel Developer Reference|
The ExportAsFixedFormat method is used to publish a workbook to either the PDF or XPS format.
Version Added: Excel 2007
expression.ExportAsFixedFormat(Type, Filename, Quality, IncludeDocProperties, IgnorePrintAreas, From, To, OpenAfterPublish, FixedFormatExtClassPtr)
expression A variable that represents a Workbook, Sheet, Chart, or Range object.
|Type||Required||XlFixedFormatType||Can be either xlTypePDF or xlTypeXPS.|
|Filename||Optional||Variant||A string that indicates the name of the file to be saved. You can include a full path or Excel 2007 saves the file in the current folder.|
|Quality||Optional||Variant||Can be set to either xlQualityStandard or xlQualityMinimum.|
|IncludeDocProperties||Optional||Variant||Set to True to indicate that document properties should be included or set to False to indicate that they are omitted.|
|IgnorePrintAreas||Optional||Variant||If set to True, ignores any print areas set when publishing. If set to False, will use the print areas set when publishing.|
|From||Optional||Variant||The number of the page at which to start publishing. If this argument is omitted, publishing starts at the beginning.|
|To||Optional||Variant||The number of the last page to publish. If this argument is omitted, publishing ends with the last page|
|OpenAfterPublish||Optional||Variant||If set to True displays file in viewer after it is published. If set to False the file is published but not displayed.|
|FixedFormatExtClassPtr||Optional||Variant||Pointer to the FixedFormatExt class.|
The following example creates the PDF at standard quality in the current file’s directory and displays file in viewer after it is published.
|An error will occur if the PDF add-in is not currently installed.|
|Visual Basic for Applications|