#VBA Solving VBA (Visual Basic for Applications) Compatibility Issues

In recent times many Microsoft Dynamics GP sites have been having issues with VBA (Visual Basic for Applications). Especially with Microsoft Office Updates breaking functionality and incompatibilities with later Windows Server releases.

There have been compatibility issues reported with sending emails via Outlook and more recently issues with VBA on Windows Server 2019.

These issues prompted Microsoft Support to publish an article explaining that VBA has reached end of life and is no longer being developed and supported.

• Microsoft Dynamics GP and VBA: Future Considerations

I wanted to highlight a couple of solutions you can explore.

Michael Nola identified that there is a VBA security update which might solve the Windows Server 2019 compatibility issue. The update changes the VBE6.DLL Visual Basic Engine file from 6.5.10.32 to 6.5.10.53. This file is located in the C:\Program Files (x86)\Common Files\Microsoft Shared\VBA\VBA6 folder. Details and Download available from the links below:

• Visual Basic for Applications Runtime Security Update
• MS10-031: Description of the security update for Microsoft Visual Basic for Applications runtime: May 11, 2010 (KB 974945)

A better solution which solves VBA compatibility issues permanently is to remove VBA entirely from your system and replace it GP Power Tools – Developer Tools Module using triggers and scripts.

It can replace almost all VBA code with more reliable and stable code using Dexterity/SQL/C#/VB.Net. It works on the web client. It can do things that Dexterity or Visual Studio Tools themselves cannot. It is much simpler to develop and maintain and has no deployment or upgrade steps needed.

For more information see the following article:

• #GPPT Replacing VBA with GP Power Tools – Developer Tools

Hope this information is useful.

David

This article was originally posted on http://www.winthropdc.com/blog.