PC Review


Reply
Thread Tools Rate Thread

Access Excel Solver from a C# Add-in

 
 
=?Utf-8?B?TXIuQmx1ZVN1bW1lcnM=?=
Guest
Posts: n/a
 
      25th Apr 2007
I'm a novice, so go easy on me. =)

I'm trying to learn C# by writing an Excel Add-in that back tests stock
trading strategies. It's more of a financial toy than a real power-house.
I'm using VS2005, VSTO for '03/'07, and running Excel 2003.

Because I am doing this for a class, one requirement is to incorporate
optimization. I figure if I could access Excel Solver, I would be able to do
much better calculations. I've written a good portion of the add-in, but I'm
realizing that accessing Excel Solver from C# is very hard to research.

Are there any MSDN articles on this? It seems Solver is only exposed to
VB.Net; how can that be?

Thanks in advance!
 
Reply With Quote
 
 
 
 
=?Utf-8?B?TXIuQmx1ZVN1bW1lcnM=?=
Guest
Posts: n/a
 
      25th Apr 2007
*bump*
I don't mean to be annoying, but there is seriously no documentation
anywhere about getting to solver from C#. How could MS expose functionality
to VBA/VB.Net and not to C#?
 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
solver add in / excel solver / vba =?Utf-8?B?amVyb21lIGRyZWFu?= Microsoft Excel Programming 8 21st Sep 2007 09:28 AM
Solver in Quick Access Toolbar causes Excel 2007 startup failure =?Utf-8?B?aW50ZXJsZWFmMg==?= Microsoft Excel Crashes 0 17th Jul 2007 07:52 PM
How to replace Excel solver with some free solver codes in Excel V =?Utf-8?B?Y3QyMTQ3?= Microsoft Excel Programming 2 8th Nov 2006 07:06 PM
I am missing solver.xla to run the excel solver add-in, please adv =?Utf-8?B?RXhjZWwgU29sdmVy?= Microsoft Excel Crashes 0 27th Mar 2006 03:11 AM
Programatically access Excel's Solver? Kevin R Microsoft Excel Programming 3 3rd Feb 2005 07:40 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 07:00 PM.