Finding which version of Excel created a file

[Guest]

Hi!
Any one know of a way to find out which version of excel was used to create
a file?

Best Regards!

Eirik

 

[Tom Ogilvy]

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.

 

[Michel Pierron]

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