Object Hierchy
 

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?

Object Hierchy
 

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

--
Regards,
Tom Ogilvy



"Dan Scholler" wrote in message
...
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?