471,348 Members | 1,378 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,348 software developers and data experts.

Excel Automation from C# (2005): COUPDAYBS

Hi,

I've written a small piece of code to pass a formula to Excel 2003,
start a calculation, receive the value back und show it in my C#
(.Net2005) WinForm. Works fine so far.

The other day I wanted to pass the following formula to my app:
"COUPDAYBS( DATE(2007;1;25); DATE(2008;11;15); 2; 1 )". This is not
working. I always receive a number like "-2146826259", which in fact
is wrong. The correct result would be 71.

Tried this in Excel itself and discovered that I need to switch on the
"Analyse-Funktionen" AddIn from Extras|Add-Ins (first add in in the
list).

How can I switch it on from within C#.

Any hint is highly appreciated!

Cheers

Andreas
Jun 27 '08 #1
0 887

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

17 posts views Thread by Mansi | last post: by
3 posts views Thread by Stephen Brooker | last post: by
6 posts views Thread by a.theil | last post: by
3 posts views Thread by saragoesnuts | last post: by
3 posts views Thread by =?Utf-8?B?YzY3NjIyOA==?= | last post: by
1 post views Thread by Ronak mishra | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.