asked on

Guidance on converting from vba to vb.net

I have and upcoming project to port an extensive vba (access) program to vb.net. Are there any books, tutorials or programs specifically targeted for vba programmers who need to learn vb.net?

Scott McDaniel (EE MVE )

There's no clear path from VBA to .NET. You'd be better off determining the major functionality of the VBA system and recreate it entirely from .NET code. While some of your VBA code might work in VB.NET, it will be kludgy and difficult to maintain, and won't take advantage of the .NET framework.

I went down your same path several years back. I'm was an experienced Access developer (MVP for 10 years, quite a few major projects under my belt, good understanding of object-oriented programming, etc etc) ... and I struggled to grasp the concepts. If you're a drag-n-dropper, then you're going to have troubles. If you're used to working mostly with code, you're still gonna have troubles (although not nearly as much as a dnd'r).

I'd suggest some basic VB.NET tutorials from Microsoft or one of the online learning places. Get your head around the concepts, try a few pet projects, and understand the basics. Once I learned Visual Studio, going back to the VBA editor feels like working with hammers and chisels :)

ASKER CERTIFIED SOLUTION

Mark Edwards

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial