| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Finding which version of Excel created a file
Hi!
Any one know of a way to find out which version of excel was used to create a file? Best Regards! Eirik |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Finding which version of Excel created a file
There are some articles in the Knowledge Base
http://support.microsoft.com However, they are written for C++ developers as I recall. There is no easily queriable attribute. -- Regards, Tom Ogilvy "Eirik" wrote in message ... Hi! Any one know of a way to find out which version of excel was used to create a file? Best Regards! Eirik |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Finding which version of Excel created a file
Hi Eirik,
May be: Sub xlFileVersion() Dim Typ As String Select Case ActiveWorkbook.FileFormat Case -4143: Typ = "Excel 2000 et plus" Case 16: Typ = "Excel 2.1" Case 29: Typ = "Excel 3" Case 33: Typ = "Sheet Excel 4" Case 35: Typ = "Workbook Excel 4" Case 39: Typ = "Excel 5" Case 43: Typ = "Excel 97/2000& 5/95" Case Else: Typ = "Unknown" End Select MsgBox "File format: " & Typ & " !", 64 End Sub MP "Eirik" a écrit dans le message de ... Hi! Any one know of a way to find out which version of excel was used to create a file? Best Regards! Eirik |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Add-in created for previous of version of Excel | Excel Discussion (Misc queries) | |||
| Which version of Excel created the file | Excel Discussion (Misc queries) | |||
| How to use excel file created in version earlier than 4.0a in 4.0 | Excel Discussion (Misc queries) | |||
| Workbook created with old version of excel | Excel Discussion (Misc queries) | |||
| Excel Version in which file was created | Excel Programming | |||
Hybrid Mode
