Reference Error

[Hap]

My project is throwing an error. I've been switching back and forth between 2000 and 2010 so I'm assuming something happened in my latest file as this hasn't occurred before.

I'm getting a "Compile Error: Can't Find Object or Library" Msgbox when compiling. The error is being thrown for objects like VBA's Date, or Time objects, which I changed to read VBA.Date but I think with the correct reference I don't need to do this. Any idea which reference is missing?

I added a reference to Microsoft ActiveX Data Objects 6.0 Library in the newer version of Excel but I don't think its available in 2000. Did adding this reference change something I didn't intend? How to correct this?

Thank you

 

[Derek Brown]

I have found that generally VBA copes when moving to a later version of Excel and may, or may not, have a problem trying to run in an earlier version.
By looking at (VBA) Tools | References you may see that a reference has been marked as 'MISSING' and that needs to be corrected. For the problem that you describe you probabably need the 2.8 (or earlier) library.