Referencing error
 

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.

Referencing error
 

Have you registered the Data object with the operating system?

(is the GUID in the registry?)

--
Regards,
tom Ogilvy

"Purnima" wrote in message
...
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.

Referencing error
 

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

"Tom Ogilvy" wrote:

Have you registered the Data object with the operating system?

(is the GUID in the registry?)

--
Regards,
tom Ogilvy

"Purnima" wrote in message
...
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.

Referencing error
 

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.

--
Regards,
Tom Ogilvy

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

"Tom Ogilvy" wrote:

Have you registered the Data object with the operating system?

(is the GUID in the registry?)

--
Regards,
tom Ogilvy

"Purnima" wrote in message
...
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.