Class FileExportConverter (Excel VBA)

The class FileExportConverter represents a file converter that is used to save files.


To use a FileExportConverter class variable it first needs to be instantiated, for example

Dim fec as FileExportConverter
Set fec = Application.FileExportConverters(Index:=1)

FileExportConverter class variables can be set using the FileExportConverters.Item procedure.

For Each

Here is an example of processing the FileExportConverter items in a collection.

Dim fec As FileExportConverter
For Each fec In Application.FileExportConverters
Next fec


Returns the description for the file converter.

Dim strDescription As String
strDescription = Application.FileExportConverters(1).Description


Returns the file name extensions associated with the specified FileExportConverter object.

Dim strExtensions As String
strExtensions = Application.FileExportConverters(1).Extensions


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

Dim lngFileFormat As Long
lngFileFormat = Application.FileExportConverters(1).FileFormat


Returns a Long that represents the number of file converters in the collection.

Dim lngCount As Long
lngCount = Application.FileExportConverters.Count


Returns an individual FileExportConverter object from a collection.

Item (Index)

Index: An integer that represents the individual object to be returned.

Dim fecItem As FileExportConverter
Set fecItem = Application.FileExportConverters(Index:=1)