Ron de Bruin wrote:
You must load the Add-ins with code if you use open Excel from a other program

When excel is started through automation, addins are not loaded to
save time. You must load them overtly.


This was suggested by KeepItCool and should work:

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

Set xl = CreateObject("Excel.Application")

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


These are canned apps calling Excel -- nothing that I have access to the code
for. Things like web browsers, OCR software, etc.

Bill