Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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?

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11,123
Default 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?

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
excel loading whyrrsd Excel Discussion (Misc queries) 0 May 13th 07 08:55 AM
Excel falls over loading... Tiscali Excel Discussion (Misc queries) 0 July 15th 06 11:45 AM
Excel 2003 crashes loading excel files created Excel 2000 Jeff Lewin Australia Excel Discussion (Misc queries) 0 June 27th 05 04:20 AM
Loading excel Mike R Excel Discussion (Misc queries) 13 March 1st 05 07:04 PM
Excel Add-In loading xlpuzzled Excel Discussion (Misc queries) 6 February 4th 05 01:00 AM


All times are GMT +1. The time now is 06:33 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"