Range.ExportAsFixedFormat Method (Excel)
Exports to a file of the specified format.
Version Information
Version Added: Excel 2007
Syntax
expression .ExportAsFixedFormat(Type, Filename, Quality, IncludeDocProperties, IgnorePrintAreas, From, To, OpenAfterPublish)
expression A variable that represents a Range 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. |
FixedFormatExtClassPtr |
Optional |
Variant |
Pointer to the FixedFormatExt class. |
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.