WinForms in Excel (2002) and add-ons

Good morning,

I am about to start writing an Excel add-in for Excel 2002. The add-in needs to call a form. Obviously, I can write the form within VBA.

My question is -- is there an easy/good way of calling a .NET (I am using 3.5) from Excel, and have the form be able to write stuff back to Excel the same way a native Excel 2002 form would?

Answers


Office XP... yes, functionally you can manipulate excel from add-in or the other way around, but obviously it requires more coding compared to VBA.

Most powerful solution is to use OLE automation, but it is not the easiest one to code and support. If you really need it and have this option - get something like http://www.add-in-express.com/ - it gives a nice wrapper over Excel automation and addresses most common problems. Anyway, add-in-express looks like the most mature product supporting Office XP and worth checking out to get better idea about how .Net code and Excel can interact.

There are multiple ways you can implement data exchange between Excel and .Net code in add-in: OLE automation, calls to COM functions from VBA, RTD, not sure if anyone still uses DDE. There are some setup effort, programming challenges, and maintenance/stability problems for each of those.


Need Your Help

PHP filter_var() - FILTER_VALIDATE_URL

php validation utf-8 filter filter-var

The FILTER_VALIDATE_URL filter seems to have some trouble validating non-ASCII URLs:

Facebook SDK 3.5 can't log in, crashes app

iphone ios objective-c facebook facebook-login

I'm using the code from HelloFacebookSample and for some reason FBLoginView crashes my app whenever it's clicked. I've copied most of the code verbatim, so I can't see why it's crashing. Does anyon...

About UNIX Resources Network

Original, collect and organize Developers related documents, information and materials, contains jQuery, Html, CSS, MySQL, .NET, ASP.NET, SQL, objective-c, iPhone, Ruby on Rails, C, SQL Server, Ruby, Arrays, Regex, ASP.NET MVC, WPF, XML, Ajax, DataBase, and so on.