For Ian Grieve, building GP macros via SQL or Word wasn’t enough, he added on Excel as well.
Microsoft Dynamics GP Macros: Macro By Excel Formula
Development & IntegrationExcel & Office
Archived post from 2017. Dynamics GP and the links it points to have changed since; check current documentation before relying on version-specific steps.