Excel toolpacks not opened?

[Karl Thompson]

Excel 2000, Win 2000, Delphi 7

When opening Excel, as below, the various financial toolpaks do not open.
For any workbooks which are opened which use the XIRR() function returns a
#NAME error. This is not a problem if I use Excel directly to open the
workbooks.

Any ideas?

TIA.

Karl


var
FExcel: _Application;
LCID: integer;
WBk: _Workbook;


{...}

FExcel := CoExcelApplication.Create;
LCID := GetUserDefaultLCID;

{...}

WBk := FExcel.Workbooks.Open( FileName, False{don't update links}, True
{open read only},
EmptyParam, EmptyParam, EmptyParam,
EmptyParam, EmptyParam, EmptyParam,
EmptyParam, EmptyParam, EmptyParam,
EmptyParam, LCID);

 

[XL-Dennis]

When automate Excel and other Office-program as well the add-ins ar not activated per se
Depending on what add-in You want to use You may in code activate it

Here You find an example in VB 6.0 for automating an Excel add-in
http://ozgrid.com/forum/viewthread.php?tid=987

Kind regards
Dennis

 

[Karl]

Thank you. This looks quite useful.