Probably add-ins are not invoked (or they look like not installed) when you start with Excel Automation.
Try something like this, and for "your" addins titles.
oExcel= CREATEOBJECT("Excel.Application")
oExcel.Workbooks.add()
lnAddins=0
for ia=1 to oExcel.Application.Addins.Count
if oExcel.Application.Addins(ia).Title $"Analysis ToolPak, Analys32"
lnAddins=ia
endif
endfor
if lnAddins=0
wait wind time 1.0 "Terminating. 'Analysis ToolPak' or 'Analys32' addins are not are available!"
return
endif
with oExcel.Application.Addins(lnAddins)
if not .Installed
.Installed=.t.
endif
endwith
......
>Hi all,
>We have some add-ins for Excel that show up automatically as toolbars when Excel is started from Explorer or a shortcut. I need them to show up when started from CreateObject('Excel.Application') or some other progid. The add-ins are visible on the add-in Tools/Add-Ins dialog but not in the toolbar list and I have no idea how to make the wretched buttons appear in the Excel toolbar space. I suppose I could start Excel with ShellExecute() and then do a GetObject(), but I'd rather just start with COM and stay there.
>
>Any hints on how to do this?
>
>Thanks.
>
>Gary