Tags: checking, excel, excel2000, house, microsoft, msdn, office, run, software, version

How do you know what version of Excel you are using?

On Microsoft » Microsoft Excel

3,759 words with 5 Comments; publish: Wed, 04 Jun 2008 00:20:00 GMT; (306140.14, « »)

Hi there,

In the house I run office xp, at work I am not sure if its excel 97 or excel

2000. Is there any way of checking this out.

I am having problems with ADO at work yet at home the code works fine?

regards Harry

All Comments

Leave a comment...

  • 5 Comments
    • Your problem is most likely going to be with the Reference you have selected

      for using the ADO... Try changing the library to a lesser version (2.5 is

      probably good enough) otherwise you can look at using late binding but that

      is a bit of a different discussion. If it is a Reference issue and you want

      to make you code completely portable then we can get into a discussion on

      late binding...

      HTH...

      Jim Thomlinson

      "Big H" wrote:

      > Hi there,

      > In the house I run office xp, at work I am not sure if its excel 97 or excel

      > 2000. Is there any way of checking this out.

      > I am having problems with ADO at work yet at home the code works fine?

      > regards Harry

      >

      >

      #1; Wed, 04 Jun 2008 00:21:00 GMT
    • Jim,

      I am using 2.5 at work and in the home, yet 2.5 doesn't work at the work.

      What is binding?

      regards Harry

      p.s

      is there a way of finding out what version of excel I use at work

      "Jim Thomlinson" <James_Thomlinson.excel.todaysummary.com.owfg-Re-Move-This-.com> wrote in message

      news:164D0747-1CA0-45A6-9DED-49AABEE58A22.excel.todaysummary.com.microsoft.com...[vbcol=seagreen]

      > Your problem is most likely going to be with the Reference you have

      > selected

      > for using the ADO... Try changing the library to a lesser version (2.5 is

      > probably good enough) otherwise you can look at using late binding but

      > that

      > is a bit of a different discussion. If it is a Reference issue and you

      > want

      > to make you code completely portable then we can get into a discussion on

      > late binding...

      > --

      > HTH...

      > Jim Thomlinson

      >

      > "Big H" wrote:

      #2; Wed, 04 Jun 2008 00:22:00 GMT
    • Big, Far be it from me to argue with the answer you already got. If

      your question is more basic than Jim is interpreting it, in the

      spreasheet view on the work machine, click on Help, then About Excel.

      James

      Big H wrote:

      > Hi there,

      > In the house I run office xp, at work I am not sure if its excel 97 or excel

      > 2000. Is there any way of checking this out.

      > I am having problems with ADO at work yet at home the code works fine?

      > regards Harry

      #3; Wed, 04 Jun 2008 00:23:00 GMT
    • "Big H д

      "

      > Hi there,

      > In the house I run office xp, at work I am not sure if its excel 97 or excel

      > 2000. Is there any way of checking this out.

      > I am having problems with ADO at work yet at home the code works fine?

      > regards Harry

      Excel Application:

      Msgbox Application.Version

      2003 --> 11

      Xp --> 10

      2000 --> 9

      Excel File last written version:

      MsgBox ThisWorkbook.CalculationVersion

      something like

      114210 where 11 is the Excel Version

      0 means no calculation made before save

      Another VBA

      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

      #4; Wed, 04 Jun 2008 00:24:00 GMT
    • MsgBox ThisWorkbook.CalculationVersion

      Missed something

      The last four digit is the sub version of Excel

      #5; Wed, 04 Jun 2008 00:25:00 GMT