Class FileExportConverter (Excel VBA)

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

Set

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

Dim lngIndex As Long: lngIndex = 
Dim fecFileExportConverter As FileExportConverter
Set fecFileExportConverter = Application.FileExportConverters(Index:=lngIndex)

The following procedures can be used to set variables of type FileExportConverter: FileExportConverters.Item and Application.FileExportConverters

For Each

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

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

Description

Returns the description for the file converter.

Dim fcTemp As FileExportConverter 
Set fcTemp = FileExportConverter(1) 
 
MsgBox fcTemp.Description

Extensions

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

Dim fcTemp As FileExportConverter 
Set fcTemp = FileExportConverters(1) 
 
MsgBox "The file name extensions for the file converter are: " & fcTemp.Extensions

FileFormat

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

Dim fcTemp As FileExportConverter 
Set fcTemp = FileExportConverters(1) 
 
MsgBox "The file format identifier for the file converter is: " & fcTemp.FileFormat

Parent

Returns an object that represents the parent object of the specified FileExportConverter object. Read-only.

FileExportConverters.Count

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

FileExportConverters.Item

Returns an individual FileExportConverter object from a collection.

Syntax : expression.Item (Index)

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

FileExportConverters.Parent

Returns an object that represents the parent object of the specified FileExportConverters object. Read-only.