Maybe, you should have a reference to the Microsoft ActiveX Data Object n.n
Library.

--
__________________________________
HTH

Bob

"burl_h" wrote in message
...
I'm having issues with this line of code.

Currently it works fine in excel 2003. however after the file is used
in excel 2007 and saved in compatability mode, it no longer works in
excel 2003. Am I missing some object libaries?

thanks
burl_h