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=Tru e
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

PS: This is a repeat post as the first went unansewered

PA