Object Hierchy

[Dan Scholler]

I have written a macro that opens up a specified .xls file
and runs functions on it using the object hierchy. How do
I open a specific Excel Add in for that file?

 

[Tom Ogilvy]

workbooks.Open Myaddin.xla

or use the addins collection

Sub LoadAddin()
Application.AddIns.Add FileName:="c:\data\myaddin.xla"
Application.AddIns("Myaddin").Installed = True
End Sub