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

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

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" wrote in message
...
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

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

"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

MsgBox ThisWorkbook.CalculationVersion

Missed something :(
The last four digit is the sub version of Excel