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


David Meego - Click for blog homepageIn 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:

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.

Please post feedback or comments

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

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