Converting Microsoft Office VBA Macros to Visual Basic .NET

Paul Cornell shows you how to migrate an Office VBA macro to .NET, specifically Visual Basic .NET and C#, and then how to transform that solution into a Visual Basic .NET managed COM add-in. (32 printed pages)

He has noticed that a lot of Microsoft Office developers out there, both in newsgroups and at conferences, are interested in learning more about how to code solutions using the Microsoft .NET development platform.

In this month’s column, He will show you to take an Office VBA macro and convert it to .NET, both in Visual Basic .NET and C#. As an added bonus, He will show you in the appendix at the end of this month’s column how to make a Visual Basic .NET managed COM add-in out of the solution.


Yes….Converting VBA Macros to VB.NET. I am sure many application in difference Dept. in your company are using VB Macro within Office Word/Excel/Access. My company is using a lot on the Excel.
One of the bad side on VBA Macros is……..Due to difference version of Office and Windows, your Macro may not function as what you expect. So, Here is a chance for you to learn how to “Convert“ them into VB.NET. From my option, this is the fastest way to keep the functions work. However, for the Best performance, sure Re-create them pure in VB.NET is another Best choose.

Converting Microsoft Office VBA Macros to Visual Basic .NET

So…..same wording again…..Get ready for the next wave.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.