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.
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.
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 184.108.40.206 to 220.127.116.11. 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:
Hope this information is useful.
This article was originally posted on http://www.winthropdc.com/blog.