Nintex Doc Gen does not support macros running on their servers. However, Nintex Doc Gen does support using templates containing macros if they are not set to trigger when the document is opened.
The workaround is to manually run the macros after the document is generated with your Salesforce data OR use the Excel-as-Middleware feature to avoid the need to use macros.