Quote:
Originally Posted by Ben McClave
Jerry,
It sounds like you don't have the Microsoft ActiveX reference set. Within the VBA Editor go to TOOLS REFERENCES and check the box next to "Microsoft ActiveX Data Objects 6.0 Library" (or the highest version number you have, if there is no 6.0 option).
Once the reference has been set, you can click Debug Compile VBAProject to see if it still gives you an error.
Ben
|
hi , i found it and put the active X 6 but still gives me an error