Thread: Object Hierchy
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default 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?