Hi!
Any one know of a way to find out which version of excel was used to create
a file?
Best Regards!
Eirik
Hi!
Any one know of a way to find out which version of excel was used to create
a file?
Best Regards!
Eirik
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" <[email protected]> wrote in message
news:[email protected]...
> Hi!
> Any one know of a way to find out which version of excel was used to
create
> a file?
>
> Best Regards!
>
> Eirik
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" <[email protected]> a écrit dans le message de
news:[email protected]...
> Hi!
> Any one know of a way to find out which version of excel was used to
create
> a file?
>
> Best Regards!
>
> Eirik
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks