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.