18,267
Hello,
VBA code is working on my computer but when it deploys on production terminal box it is not executing at all.
Any hlep on this is highly appreciable.
Thanks much
Sandip
*This post is locked for comments
Hello Derek,
Appreciate for your reply. Let me try your suggestion and update you status.
Thanks much
Sandip
What version of Office is being run on your computer compared to the terminal server? I ask to make sure you're not running into what's mentioned in this blog:
community.dynamics.com/.../dynamics-gp-and-vba-future-considerations
Otherwise, when the VBA doesn't execute on the production terminal, is there any type of error message, or does it simply not work/fire at all?
One thing you can try is the following:
1. From the working machine, go into Customization Maintenance and make a package file containing all of the modified forms, reports, VBA objects, etc.
2. On the terminal server, have all users log out of Dynamics GP, then take all of the .vba files from the GP directory as well as any forms or reports dictionary files, and put them into a backup folder.
3. On the terminal server still, login to GP as sa and in the Customization Maintenance window, import the package file in from step #1, which will re-create the .vba files and the forms and reports dictionary files. Test the VBA again on this server to see if it's now working or not.
We've also seen where you need to launch Dynamics GP as 'Run As Administrator' to get the VBA to fire, so try that as well on the terminal server if you haven't already done so.
Let us know if you have any questions.
Thanks
#1
André Arnaud de Cal...
291,735
Super User 2024 Season 2
#2
Martin Dráb
230,466
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
