Detect file format (version) of Excel file
 

Is it possible in VBA to determine the file format (Excel 97, etc.)
of a spreadsheet without opening the file?

Thanks, Alan

Detect file format (version) of Excel file
 

Try :
Set fso = CreateObject("scripting.filesystemobject")
Set f = fso.getfile("e:\temp\sample.xls")
MsgBox f.Type

I don't know better...
Daniel
Is it possible in VBA to determine the file format (Excel 97, etc.)
of a spreadsheet without opening the file?

Thanks, Alan