Enrolling a .dll file in Excel

[PeterA]

I have developed a program which makes use of ccrpTmr.dll file located in the folder C:\MyDocuments (which also houses the main Addin file).

I want to programmatically enroll this dll file along with the addin file when a workbook is opened.. Using

Private Sub Workbook_Open()
Application.Addins.Add("C:\MyDocuments\prjName.xla")
Addins("C:\MyDocuments\prjName.xla").Installed=True
End sub

the addin is not only enrolled in the collection but also installed (checked) in the Addins dialog box under Tools--->Addins.

For now, the dll file is manually loaded the usual way (In the VBE, Tools-->References-->Browse etc).

Any leads will be appreciated

PeterA