Detect file format (version) of Excel file

's Computer Specifications

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

Thanks, Alan

's Computer Specifications

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

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
import file so that it is a actual csv file, no excel cell version	broncoburt	Microsoft Excel New Users	1	21st Nov 2009 09:09 PM
Determine Excel file version with no file extension.	tjlumpkin	Microsoft Excel Misc	2	23rd Jul 2009 06:59 AM
QUERY: detect MS Installer or any exe file Version Number?	Dhruba Bandopadhyay	Windows XP General	2	8th Jul 2006 02:55 AM
QUERY: detect MS Installer or any exe file Version Number?	Dhruba Bandopadhyay	Windows XP Help	2	8th Jul 2006 02:55 AM
Is there anyway to export a report file to CSV file format instead of Excel file format? THANKS!!! <END>	Sean	Microsoft Access	6	2nd Mar 2005 01:45 AM