Inserting a analysis toolpak function with C#
 

Hello every body,

first of all I'm new to the Microsoft Office programmation.

I use Excel 2003, VS.net 2005 and I have the Analysis ToolPak loaded

I made a little programme in C# to write function into Excel sheet
cells. When I write function from the analysis toolpak with my C#
programme, I see the typical #NAME?.

If I double click on the cell and press "enter" the function is
calculated and the #NAME? run away and is replaced by the value of the
function.

If I write with my C# programe an other function like "=SUM(2,4)" it
work just fine, I have the evaluation when I open my excel document

What should I do to right analysis toolpak function in the excel sheet
and have them been understood and evaluated by excel ?

Many thank's for your help and your responces

Clair