Worksheet.ExportAsFixedFormat (Excel)

Exports to a file of the specified format.

This method also supports initializing an add-in to export a file to a fixed-format file. For example, Excel will perform file format conversion if the converters are present. The conversion is usually initiated by the user.

ExportAsFixedFormat (Type, Filename, Quality, IncludeDocProperties, IgnorePrintAreas, From, To, OpenAfterPublish, FixedFormatExtClassPtr, WorkIdentity)

ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF


The following argument is required

Type (XlFixedFormatType) - The type of file format to export to.

Possible return values are xlTypePDF - "PDF" - Portable Document Format file (.pdf), xlTypeXPS - "XPS" - XPS Document (.xps).

Optional arguments

The following arguments are optional

Filename (String) - The file name of the file to be saved. You can include a full path, or Excel saves the file in the current folder.

Quality (XlFixedFormatQuality) - Optional XlFixedFormatQuality. Specifies the quality of the published file.

Possible return values are xlQualityMinimum - Minimum quality, xlQualityStandard - Standard quality.

IncludeDocProperties (Boolean) - True to include the document properties; otherwise, False.

IgnorePrintAreas (Boolean) - True to ignore any print areas set when publishing; otherwise, False.

From (Long) - The number of the page at which to start publishing. If this argument is omitted, publishing starts at the beginning.

To (Long) - The number of the last page to publish. If this argument is omitted, publishing ends with the last page.

OpenAfterPublish (Boolean) - True to display the file in the viewer after it is published; otherwise, False.

FixedFormatExtClassPtr - Pointer to the FixedFormatExt class