FileExportConverter.FileFormat Property (Excel)
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.
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.
ActiveWorkbook.SaveAs _
Filename:="C:\temp\myFile.xyz", _
FileFormat:=Application.FileExportConverters(1).FileFormat, _
CreateBackup:=False