Hi,
Am actually trying to find the extension of a file with the XL File Format
Enumeration as the input. For example, the XL File Format Enumeration for
".csv" file is 6, so if I give the input as 6, the output should be ".csv".

Is there a way to do this?

Thanks in advance.

AFAIK there is no direct way to return the default file extensions
associated with a given file format.

Typically you won't be working with many of them so why not hard code them
against a lookup table, or even simply

Select Case myFileFormat
case xlCSV: sExt = ".csv"
case xlWorkbookNormal, 56: sExt = ".xls"
case 51: sExt = ".xlsx"
' etc
end Select

Regards,
Peter T

"Sasikumar Kannappan" wrote
in message ...
Hi,
Am actually trying to find the extension of a file with the XL File Format
Enumeration as the input. For example, the XL File Format Enumeration for
".csv" file is 6, so if I give the input as 6, the output should be
".csv".

Is there a way to do this?

Thanks in advance.

Thanks for the response Peter. That's the solution am using right now, wanted
to check if there's anything else available :)

"Peter T" wrote:

AFAIK there is no direct way to return the default file extensions
associated with a given file format.

Typically you won't be working with many of them so why not hard code them
against a lookup table, or even simply

Select Case myFileFormat
case xlCSV: sExt = ".csv"
case xlWorkbookNormal, 56: sExt = ".xls"
case 51: sExt = ".xlsx"
' etc
end Select

Regards,
Peter T

"Sasikumar Kannappan" wrote
in message ...
Hi,
Am actually trying to find the extension of a file with the XL File Format
Enumeration as the input. For example, the XL File Format Enumeration for
".csv" file is 6, so if I give the input as 6, the output should be
".csv".

Is there a way to do this?

Thanks in advance.