Starting addins when Excel is opened via Automation

[Simon Gosney]

Hi everyone

I see from reading previous posts that addins are not loaded when
Excel is started via automation.

Does anyone have a way to work around this without either amending the
C++ code that creates the Excel object or adding code to load the
addin into the workbook open event of each spreadsheet? Can Excel be
forced to load addins when its opened via automation?

Any help would be very much appreciated.

Thanks

Regards

Simon

 

[Charles Williams]

Hi Simon,

You can load addins (.xla) for the duration of an excel session by opening
them as though they were an .xls file.

So try either
- open the addin from code
- place the addin in XLSTART (not sure if this works with automation?)

Charles
______________________
Decision Models
FastExcel Version 2 now available.
www.DecisionModels.com/FxlV2WhatsNew.htm

 

[Bob Phillips]

I don't think it does pickup XlStart files, so the file would need to be
explicitly opened.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Simon Gosney]

'fraid it doesn't load XLSTART files.

I think the only way is to load the addins when the object is created in
the C++ code...

Thanks anyway though!

Simon

 

[JDK]

At my workplace we use a small xls which has a little query on it an
loads an addin from a directory. it is placed in the XLStart director
in office. It has worked since office 4.0 and is still working i
Office 2003. the addin doesn't work right but the automation is stil
there by placing it in the xlstart directory.
The addin itself is old, and worked on office 2000. It calls a
Intersolve Oracle7 driver and loads it automatically