Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Dynamics GP Client Vir...
Finance | Project Operations, Human Resources, ...
Suggested answer

Dynamics GP Client Virtualization, Remote Desktop or VDI? I don't want to lose VBA when opening Excel attachments.

(0) ShareShare
ReportReport
Posted on by John Metaxas at Harris 5

Most of us have used Remote Desktop for our "Dynamics GP" Clients for a long time.   

But here we are using Windows Server 2016 that is due to sunset in January of 2022. 

The Natural Assumption is to upgrade to 2019.  Which makes sense except VBA will not run on 2019.  

For some this is a big deal,  most of their screen mods are written in VBA. 

The standard answer is to rewrite the Mods in VStools or Dexterity.

Fine problem solved!  But what about all the VBA invested in the many documents that may be attached in Dynamics GP?

I want my users to be able to click on an attachment in GP and the Document and have the VBA to work.

So what about running VDI? 

Running Windows 10 Session definitely fits into the "Dynamics GP" compatibility matrix and VBA will be around a long time.

What I am surprised to see is there is so little information on using VDI with "Dynamics GP" 

Does anyone care to share their experiences in this regard? 

Categories:
Microsoft Dynamics GP
  • Joseph Markovich Profile Picture
    Joseph Markovich 3,914 on at
    RE: Dynamics GP Client Virtualization, Remote Desktop or VDI? I don't want to lose VBA when opening Excel attachments.

    I have been thinking about this today (randomly) and wanted to give my opinions.

    Considering VDI, it is essentially just a Windows 10 instance, so I also don't see any reason why it wouldn't work. Am currently testing this, so I will let you know!

    On the Windows Server 2016 point, it is going end of life next January, but the security updates continue until 2027. I haven't been rushing to replace 2016 yet -- there's still support for it.

    Joe

  • Tim Wappat Profile Picture
    Tim Wappat 5,703 on at
    RE: Dynamics GP Client Virtualization, Remote Desktop or VDI? I don't want to lose VBA when opening Excel attachments.

    Although it is not officially supported, VDI is pretty sophisticated these days and I can't see any reason why it would not work. You need to talk to the vendor of that particular solution about doing some testing.

    This thread may help you, especially Beat who has used it.

    community.dynamics.com/.../windows-virtual-desktop-and-gp

    Tim

  • Steve Rodionoff Profile Picture
    Steve Rodionoff 261 on at
    RE: Dynamics GP Client Virtualization, Remote Desktop or VDI? I don't want to lose VBA when opening Excel attachments.

    Despite it not being officially supported i have found VBA still works on Server 2019.

    We have numerous customers on server 2019 using VBA without apparent issues.

    The Dynamics GP media installs the vba runtime as normal on server 2019.

    You also have to perform the following additional step or Dynamics GP will crash when executing any vba related code.

    On each server you must exclude the Dynamics.exe from DEP (Data Execution Prevention) OR only enable DEP for essential Windows programs and services. (system properties-> Performance Options -> DEP)

    I always recommend testing this first in UAT before going live with your specific configuration.

    good luck!

  • Suggested answer
    Derek Albaugh Profile Picture
    Derek Albaugh on at
    RE: Dynamics GP Client Virtualization, Remote Desktop or VDI? I don't want to lose VBA when opening Excel attachments.

    Migrating VBA to Dexterity or Visual Studio Tools, i.e. C#.NET or VB.NET is the option mostly recommended.

    Other than maybe Citrix, I haven't really heard of VDI and Dynamics GP.  The only virtual environments formally tested on are Hyper-V and App-V, per system requirements, but we do see others used.

    Hopefully the Community will have more personal experience with VDI and then VBA on it.

    Thanks

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,409 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans