Adding & Loading Add-In at Run Time.

[Robeen]

An Access DB [accdb] I am working on uses a Third-Party Add-In.


This Add-In has to be manually Added/Loaded when the DB is opened in Design View.

Is there a way to do this programmatically at Run Time?

I'd appreciate any help/pointers/feedback/comments I can get. Thanks!!

[Robeen]

The only thing close to what I'm looking for is this snippet to install an Excel AddIn:

Sub InstallAddIn()
    Dim AI As Excel.AddIn
    Set AI = Application.AddIns.Add(Filename:="C:\MyAddIn.xla")
    AI.Installed = True
End Sub

Not sure if/how this translates into Access.
I'm hoping that it will be similarly simple in Access!
??