ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   excel loading add-in.. (https://www.excelbanter.com/excel-programming/387085-excel-loading-add.html)

[email protected]

excel loading add-in..
 
I am currently creating a web application in which i use ole
automation to run excel through jscript on a webpage and then
inputting/retrieve the numbers that are being calculated. The problem
i have is when i start the excel application through activexobject,
the add-ins that i need will not load. I am kind of new at
jscript....are there anyway of loading it manually?


Ron de Bruin

excel loading add-in..
 
the add-ins that i need will not load
Correct

See this example
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



--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


wrote in message oups.com...
I am currently creating a web application in which i use ole
automation to run excel through jscript on a webpage and then
inputting/retrieve the numbers that are being calculated. The problem
i have is when i start the excel application through activexobject,
the add-ins that i need will not load. I am kind of new at
jscript....are there anyway of loading it manually?



All times are GMT +1. The time now is 05:11 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com