| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Spreadsheet (version 1).xls: file format is not valid | Excel Discussion (Misc queries) | |||
| import file so that it is a actual csv file, no excel cell version | New Users to Excel | |||
| Determine Excel file version with no file extension. | Excel Discussion (Misc queries) | |||
| Detect if an excel file is open | Excel Programming | |||
| Detect macros in an Excel file | Excel Programming | |||
![Alan[_8_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
