Detect file format (version) of Excel file

A

Alan

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

Thanks, Alan
 
D

Daniel.C

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

I don't know better...
Daniel
 
Top