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