Discussion Board for collaboration on Qlik NPrinting.
In an excel template, i've written a vba code under the Open event of the worksheet (to auto fit certain columns because the wrapping is not displaying all the cell content).
But the excel document that is generated by NPrinting (using v16.4) doesn't contain this code anymore, the Open event is empty.
Can someone suggest a solution?
Since your template is an Excel Macro Enabled Workbook (.xlsm) your output format should be set to the same. See this thread for an example: Index on page loop excel
HTH - Daniel.
View solution in original post
This is not something I have tried, but I can't see why it would lose the macro.
Mentioning los and ngulliver as they may have some insights on this.
Many thanks Daniel.
Indeed I adjusted the output format and it worked.