Referencing error

[Purnima]

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.

 

[Tom Ogilvy]

Have you registered the Data object with the operating system?

(is the GUID in the registry?)

 

[Purnima]

No, but the filename and path that I'd specified was correct. Shouldn't that
work then?

 

[Tom Ogilvy]

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.