Object Hierchy

D

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?
 
T

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
 
Top