Export Method

  • Article

Export method as it applies to the and PivotTable object.

Saves the specified PivotTable list to a file and optionally opens it in Microsoft Excel.

expression.Export(Filename, Action)

*expression   * An expression that returns a PivotTable object.

Filename    Optional String. Specifies the file name of the saved file. If you do not specify this argument, a temporary file is created in the user's temporaryfolder (the location of the temporary folder varies by operating system).

PivotExportActionEnum

PivotExportActionEnum can be one of these PivotExportActionEnum constants.
plExportActionNone
plExportActionOpenInExceldefault

Export method as it applies to the Spreadsheet object.

expression.Export(Filename, Action, Format)

*expression   * An expression that returns a Spreadsheet object.

Filename    Optional String. Specifies the file name of the saved file. If you do not specify this argument, a temporary file is created in the user's temporary folder (the location of the temporary folder varies by operating system). You must specify this argument if the Action argument is set to ssExportActionNone.

SheetExportActionEnum

SheetExportActionEnum can be one of these SheetExportActionEnum constants.
ssExportActionNone
ssExportActionOpenInExceldefault

SheetExportFormat

SheetExportActionEnum can be one of these SheetExportActionEnum constants.
ssExportAsAppropriatedefault
ssExportHTML

ssExportXMLSpreadsheet

Example

As it applies to the Spreadsheet object.

This example exports the active worksheet to the specified file.

Sub ExportSpreadsheet()

    Dim ssConstants

    Set ssConstants = Spreadsheet1.Constants

    Spreadsheet1.Export "ssheet1.htm", ssConstants.ssExportActionNone, _
        ssConstants.ssExportXMLSpreadsheet

End Sub

Applies to | PivotTable Object | Spreadsheet Object

See Also | ExportPicture Method | ExportXML Method