Thread: Detect file format (version) of Excel file
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Daniel.C[_2_] Daniel.C[_2_] is offline
external usenet poster
  
Posts: 105
Default 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


Reply With QuoteReply With Quote