Referencing error

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,
When I try to programmatically add a reference to an ActiveX Data object
Library I get an Application-defined or Object-defined error.

ThisWorkbook.VBProject.References.AddFromFile _
Filename:="C:\Program Files\Common Files\System\ado\msado21.dll"

This is where I get the error. I also tried this:

ThisWorkbook.VBProject.References.AddFromGuid _
GUID:="{ 00000205-0000-0010-8000-00AA006D2EA4 }", Major:=2, Minor:=5


But I still get the same error.
Can someone tell me why this is happening?

Thanx.
 
Have you registered the Data object with the operating system?

(is the GUID in the registry?)
 
It has to be registered in the operating system. If you go to
tools=>References and you can't find it there, then it is not registered
with the operating system.
 
Back
Top