Worksheet.ExportAsFixedFormat Method
Exports to a file of the specified format.
Version Information
Version Added: Excel
Syntax
expression.ExportAsFixedFormat(Type, Filename, Quality, IncludeDocProperties, IgnorePrintAreas, From, To, OpenAfterPublish)
expression A variable that represents a Worksheet object.
Parameters
| Name | Required/Optional | Data Type | Description |
|---|---|---|---|
| Type | Required | XlFixedFormatType | The type of file format to export to. |
| Filename | Optional | Variant | 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 | Optional | Variant | Optional XlFixedFormatQuality. Specifies the quality of the published file. |
| IncludeDocProperties | Optional | Variant | True to include the document properties; otherwise False. |
| IgnorePrintAreas | Optional | Variant | True to ignore any print areas set when publishing; otherwise False. |
| 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 | True to display the file in the viewer after it is published; otherwise False. |
Remarks
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.