Inserting a analysis toolpak function with C#

J

johnsonclair

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Inserting an analysis toolpak function in a Cell with C# 5
analysis toolpak problem 2
Analysis Toolpak Loaded or Not 0
Analysis Toolpak Problem 0
Excel VBA 2003: how do I call an Analysis ToolPak function within 7
Code to install Analysis ToolPak at Workbook Open 2
Working outlook via vba code with xlsx - error 0
Problem with SET & REF function 0

Top