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.