You’re offline. This is a read only version of the page.
Announcements
40
I'm surprised nobody suggested using Visual Studio Tools for Microsoft Dynamics GP. I switched from VBA to that years ago as VB.Net is very similar to VBA and it made the coding transition easy. Also, Visual Studio Tools is much more capable than VBA.
We are currently on GP2018 and I am using Visual Studio 2019. Install the SDK located on the GP install media, in the Tools - SDK - VS Tools folder. I believe the Programmers Guide pdf gets installed as well so you can look it over. After installing Visual Studio 2019 you can go to Extensions and install the Microsoft Dynamics GP Item and Project Templates.
Whilst not using Dynamics, this thread helped me understand why a legacy Access application was suffering. Thanks!
Yikes!
Sorry for the confusion Michael
Indeed this one has us scratching our heads.
Hi Enrique,
Actually it is Michael, not Deepak (guess I should remember to sign my posts. Believe Deepak originated this BLOG chain. Had added my question to Justin, who also placed a response to this chain, wondering about what the true underlying cause is with the Windows 2019 O/S and GP/VBA.
Take care,
Michael J. Nola.
Hi Enrique,
Noting that the link on the page that I posted isn't working. What you want to look for is "www.microsoft.com/.../details.aspx. In case this link doesn't work either, then look for "Visual Basic for Applications Runtime Security Update", Knowledge Base Article KB974945.
I personally haven't tried downloading/installing the update, as my client that I was working with already had the DLL available, but can clearly see "Vbe6.dll 6.5.10.53" listed at the bottom of the KB article's Additional Information page.
We are definitely pushing to get all our clients off of VBA, but even with a workaround, you never know what might break it next! Just went through the process of changing DOCX to PDF to get around the new MS Security Update that breaks DOCX documents generated from GP Templates and switching from MAPI to Exchange to get around the Outlook/GP/VBA crashing issue.
Glad to learn about this option as it buys us some time to communicate to the customer and get approval to re-develop these customizations.
Hi Terry,
As noted in my post "Not sure where they found the newer VBE6.DLL file". However, a Google Search points to 6.5.10.53 as being a security fix, which the client must have applied on one of their older Servers.
The following link (www.microsoft.com/.../details.aspx looks like it might do the job.
Regardless of this, do you know the underlying cause to why VBA stops working on Windows 2019?
Expect the above will only be a temporary workaround and that there is no guarantee that a new Windows 2019 security update won't break things again. And, yes, we need to get the client off of VBA sooner than later, but that is going to take quite a bit of time/resources due to the volume of modifications made using VBA through the years in their environment.
Michael, can you provide the link from the customer for the 6.5.10.53 so it can be reviewed as a future consideration of what they did to get this working, thanks
Terry
Microsoft
Hi Justin,
Have a client that is in the same boat in that they are in process of upgrading all their Servers to Windows 2019 and eventually upgrading GP as well. They have an extensive amount of VBA (that needs to be converted) and ran into the same GP Crashing issue anytime VBA code was touched on.
However, one of the client's techs found that replacing the VBE6.dll with a later version got them past the crashing issue. Albeit, this is a temporary workaround, as there is no guarantee that there won't be a Security Update that breaks things again (like the Office Suite security update that broke DOCX files that you so kindly posted about in another link). Not sure where they found the newer VBE6.DLL file, but the version information that was able to find is below:
Crashing version ==> 6.5.10.32
Working version ==> 6.5.10.53
Location C:\Program Files (x86)\Common Files\microsoft shared\VBA\VBA6
When searching the internet and other sites such as this, haven't found any mention of the temporary workaround mentioned above. Wondering what it is with Windows 2019 that stops GP/VBA combo from working? As noted, this temporary workaround resolves the GP crashing issue, but does not fix the GP/VBA/Outlook (Email) crashing issue, which requires an earlier version of Office, no VBA or switching from MAPI to Exchange.
So, wondering what your thoughts are on this?
Regards,
Michael.
#1
André Arnaud de Cal...
291,359
Super User 2024 Season 2
#2
Martin Dráb
230,370
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
