![]() |
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? |
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