We help IT Professionals succeed at work.

Guidance on converting from vba to vb.net

cmccurdy
cmccurdy asked
on
85 Views
Last Modified: 2018-09-04
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?
Comment
Watch Question

Scott McDaniel (EE MVE )Infotrakker Software
CERTIFIED EXPERT
Most Valuable Expert 2012
Top Expert 2014

Commented:
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 :)
Chief Technology Officer
CERTIFIED EXPERT
Commented:
This problem has been solved!
(Unlock this solution with a 7-day Free Trial)
UNLOCK SOLUTION