Announcements
25
I'm trying to get some help clarification on macros.
Currently when we build the macro then mail merge and save the file as updatefile.mac.
The user currently says that the updatefile.mac has to be open on a computer and then on a different computer with GP they chose Inventory>Item>Tools>Macro>Play...
Why does the updatefile.mac need to be open? If we don't have it open we get an error.
Thanks
GP Version GP2013
When you record a macro, it will track the window you currently have open.
When you replay the macro, you will need to start with that same window open.
Sometimes it is better to start with no windows open and open the window as the first part of the macro.
If you are creating a mail merge macro, it will probably need the window open to start with so that each loop comes back to the same location in the application.
https://winthropdc.wordpress.com/2008/10/29/how-to-use-word-mail-merge-and-macros-to-import-data/
One thing to try is changing the macro with notepad.exe to change the first NewActiveWin to ActivateWindow.
Personally, I would not macros as they cannot handle any variations and can only toggle checkbox (can't set to true or false).
A better approach is to drive the user interface with code using a tool like GP Power Tools. While it is possible with VBA (end of life), or VSTools or Dexterity it is much more work and needs external tools.
Regards
David
#1
Martin Dráb
601
Most Valuable Professional
#2
Abhilash Warrier
416
#3
Adis
384
Super User 2025 Season 1
Share
Report
All responses (
Answers (
