VBA Code not copied in generated excel file

[#1]

Hello all,

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?

stevedark‌

ath‌

[stevedark]

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.

Good luck!

Steve

[Daniel_Jenkins · Accepted solution]

Hi Jean-Pierre,

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.

[#4]

Super!

Many thanks Daniel.

Indeed I adjusted the output format and it worked.