Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default 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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2002 Analysis ToolPak Regression Analysis Help Requested MH Excel Worksheet Functions 1 February 28th 09 07:16 AM
Analysis Toolpak-Confidence Level and data analysis questions MH Excel Worksheet Functions 0 January 3rd 09 06:15 PM
Yield() function missing from XL2007 SP1 ATPVBAEN Analysis ToolPak Ron West Excel Worksheet Functions 8 November 14th 08 11:30 AM
Analysis ToolPak installed but no Data Analysis option Eric Stephens Excel Discussion (Misc queries) 3 February 2nd 05 09:17 PM
My XIRR function has dropped out, analysis toolpak doesn't fix. Jake Excel Worksheet Functions 3 December 15th 04 09:25 PM


All times are GMT +1. The time now is 10:43 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"