Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

Worksheet.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 Worksheet 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.




Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.