View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Peter T Peter T is offline
external usenet poster
 
Posts: 5,600
Default Retrieving Excel File extension based on XL File Format Enumeratio


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.