0

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

Improve this question

2 Answers 2

Reset to default
1

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).

Improve this answer
Sign up to request clarification or add additional context in comments.

2 Comments

i dont know what exactly an add-in is. My project is like an VBA designed interface with buttons that manipulate data in excel workbook and in Access database. The users are workers so open the excel then hit the menus to load those add-ins seems not an easy task..
Your project is an Add-in. You've written in it VBA, but a tool like Add-in Express makes it easier to write more capable Add-ins.
0

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.

Improve this answer

2 Comments

I'm not sure about almost the same. The libraries are quite different. But if you are using to writing VBA, VB.NET will feel reasonably familiar. P.S. Don't forget to accept the answer!
You'll have to buy a real version of Visual Studio. It will be cheaper in the long-run than plugging on with VBA.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.