FileExportConverter.FileFormat Property

Excel Developer Reference

Returns an integer that identifies the file format associated with the specified FileExportConverter object. Read-only.

Version Information
 Version Added:  Excel 2007

Syntax

expression.FileFormat

expression   A variable that represents a FileExportConverter object.

Example

The following example displays the file format identifier for the first file converter in the FileExportConverters collection.

Visual Basic for Applications
  Dim fcTemp As FileExportConverter
Set fcTemp = FileExportConverters(1)

MsgBox "The file format identifier for the file converter is: " & fcTemp.FileFormat

The following example shows how to use the file format identifier as a parameter in the SaveAs method of the Workbook object to save a file using the first file converter in the FileExportConverters collection.

Visual Basic for Applications
  ActiveWorkbook.SaveAs _
    Filename:="C:\temp\myFile.xyz", _
    FileFormat:=Application.FileExportConverters(1).FileFormat, _
    CreateBackup:=False