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

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

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