Excel toolpacks not opened?

K

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);
 
Top