However, if I have Excel open at the time all works well. This problem
does not arise with Word. Nor does it arise with Excel in VB5.
I have Delphi 4 pro and Office97 pro installed.
The solution to my problem seems to be that if "Analysis ToolPak" is
installed there is a problem otherwise there is not. ToolPak can be
added by code such as :
XLApp.AddIns.Item ['Analysis ToolPak'].Installed := True;
However, it takes an age to add ToolPak at run time. If I may amend my
original question. Is there a way to have ToolPak functionality
without slowing the programs run time.