Migrate to .NET
If you are an experienced VBA programmer, you’ve got a good start on learning Visual Basic .NET; however, there are significant language differences, so be prepared for a learning curve and don’t expect to be able to cut and paste code from an Excel VBA project into Visual Basic .NET and have the code run.
Existing Excel VBA code may provide a template for Visual Basic .NET code, but Visual Basic .NET is really a different language from Excel VBA. There are large as well as subtle differences. If you are new to Visual Basic .NET, you will save a great deal of time by buying and reading one of the many books on Visual Basic .NET. One of the best, in my opinion, is Programming Microsoft Visual Basic 2005 by Francesco Balena (Microsoft Press).
The following sections list a few recommendations that may make your transition easier.
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access