hmm...

posed or posted :)

note it should be

for each ai in xl.Addins




--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


Tom Ogilvy wrote :

Checked off means you want them loaded. Excel then decides whether
to load them or not.



Anyway, here is some sample code previously posed by KeepItCool

code from KeepItCool (Oct 21, 2004)
Sub LoadXLwithAddins()
Dim xl As Object
Dim ai As Object


Set xl = CreateObject("Excel.Applicatio*n")


For Each ai In Application.AddIns
If ai.Installed Then
xl.Workbooks.Open(ai.FullName)*.RunAutoMacros 1
End If
Next


xl.Visible = True
Set xl = Nothing
End Sub