开发者

Excel vba project in VB.NET

开发者 https://www.devze.com 2023-02-13 08:39 出处：网络

I am now engaging in an excel vba project. It\'s a excel front开发者_开发问答 interface for the workers in a site with an Access database in the company network. I dont like much the VBE in Excel 2007

相关专题：excel

I am now engaging in an excel vba project. It's a excel front开发者_开发问答 interface for the workers in a site with an Access database in the company network. I dont like much the VBE in Excel 2007, so im wandering if I can do this with VB.NET, which seems to be a more adorable IDE. And where can I find some resources on this? Or recommanded books? Thanks!

Im using Excel 2007 et VB.NET 2008

You could also try Excel-DNA (free). There are many other products out there too. You can make it work with VB.Net Express also, you just need to add a reference to your excel SDK. Also, Add-in Express looks pretty nice. I've never tried it though (costs money).

I think you are looking for Visual Studio Tools for Office: VSTO.

This allows you to develop using VB.NET (or indeed C#) but with full access to the Office automation facilities.