Information
The topic you requested is included in another documentation set. For convenience, it's displayed below. Choose Switch to see the topic in its original location.

Range.ExportAsFixedFormat Method

Office 2007
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

NameRequired/OptionalData TypeDescription
TypeRequiredXlFixedFormatTypeThe type of file format to export to.
FilenameOptionalVariantThe file name of the file to be saved. You can include a full path, or Excel 2007 saves the file in the current folder.
QualityOptionalVariantOptional XlFixedFormatQuality. Specifies the quality of the published file.
IncludeDocPropertiesOptionalVariantTrue to include the document properties; otherwise False.
IgnorePrintAreasOptionalVariantTrue to ignore any print areas set when publishing; otherwise False.
FromOptionalVariantThe number of the page at which to start publishing. If this argument is omitted, publishing starts at the beginning.
ToOptionalVariantThe number of the last page to publish. If this argument is omitted, publishing ends with the last page.
OpenAfterPublishOptionalVariantTrue to display the file in the viewer after it is published; otherwise False.
FixedFormatExtClassPtrOptionalVariantPointer 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.




Community Additions

Show:
© 2014 Microsoft