| title | keywords | f1_keywords | api_name | ms.assetid | ms.date | ms.localizationpriority | ||
|---|---|---|---|---|---|---|---|---|
Range.ExportAsFixedFormat method (Excel) |
vbaxl10.chm144246 |
|
|
9786c633-e9bd-3ce3-0246-7bcb3c4b4ce1 |
05/10/2019 |
medium |
Exports to a file of the specified format.
expression.ExportAsFixedFormat (Type, FileName, Quality, IncludeDocProperties, IgnorePrintAreas, From, To, OpenAfterPublish, FixedFormatExtClassPtr)
expression A variable that represents a Range object.
| 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. |
| FixedFormatExtClassPtr | Optional | Variant | Pointer to the FixedFormatExt class. |
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.
[!includeSupport and feedback]