Avatar of cmccurdy
cmccurdy
Flag for United States of America 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?
Visual Basic.NETVBA

Avatar of undefined
Last Comment
Mark Edwards

8/22/2022 - Mon
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

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Your help has saved me hundreds of hours of internet surfing.
fblack61