excel loading add-in..

S

shoelow69

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?
 
R

Ron de Bruin

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top