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.