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.


--
MattShoreson
------------------------------------------------------------------------
MattShoreson's Profile: http://www.excelforum.com/member.php...fo&userid=3472
View this thread: http://www.excelforum.com/showthread...hreadid=539799

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