I take it that you are using NPrinting 16.x (as 17.x does not support macro enabled Office documents). Take a look at this example that uses a macro enabled workbook template that creates a Table of Contents when opened: Index on page loop excel
HTH - Daniel.
That is correct, I am using NPrinting 16.4 currently. My macro enabled template adds in the fields which are used to pull data from my QV application. The problem is, that when NPrinting runs the report. It uses the template but the macro does not run. The report is then generated without returning any data. Please see below screenshots for a better explanation. When I open the template inside the template editor, the macro runs fine without any issues. The problem is just when NPrinting uses the template to create the report, it does not open the template it seems.
Below are the fields the macro copies automatically when the template is opened
The macro then pastes the fields below into sheet1. So now when the report is ran, Nprinting should look for the values of these fields inside the QV application and update row 3. The data should be similar to row 2 which used the same fields. Instead, nothing returns because the template I believe is not opened when the report is generated which causes the fields to not be copied over into row 3 which returns no values.