Set addin reference at runtime.

[MattShoreson]

Does anyone know how to do this? I'm stumped.

Dim addREF As Reference
addREF.Collection.Item

there's no Add method!

Any ideas gratefully recieved
CIA,
Matt.

[Duncan]

Private Sub Workbook_Open()
AddIns("Analysis ToolPak").Installed = True
End sub.


Have you tried recording a macro when selecting the add-in? it returns
something like the above.

HTH

Duncan