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.
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:
Hope this information is useful.
David
This article was originally posted on http://www.winthropdc.com/blog.
I read that support for GP ends in 2025. So, “is GP really here to stay” as some people say it is?
LikeLiked by 1 person
Hi John. If you are talking about the article by Third Stage. That is just incorrect FUD. I have asked for it to be changed/removed as has Terry Heley from Microsoft.
Look at articles from Microsoft employees and MVPs. https://winthropdc.wordpress.com/2021/07/08/msdyngp-its-official-microsoft-dynamics-gp-is-here-to-stay/
LikeLiked by 1 person
Is GP going away? That’s my question:)
LikeLiked by 1 person
Support for GP 2015 ends in 2025, support for GP 2018 ends in 2028. There is no end date for GP (modern lifecycle). GP IS NOT GOING AWAY. Please read the article on my blog which links to the Microsoft blog by Terry and the Microsoft Lifecycle page.
LikeLiked by 1 person
Thank you, Dave! You are and always have been a class act!
LikeLiked by 1 person