topic Re: VBA Code not copied in generated excel file in Qlik NPrinting

VBA Code not copied in generated excel file

Thu, 24 Nov 2016 09:46:14 GMT

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‌

Re: VBA Code not copied in generated excel file

stevedark — Thu, 24 Nov 2016 13:08:16 GMT

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

Re: VBA Code not copied in generated excel file

Daniel_Jenkins — Thu, 24 Nov 2016 19:20:39 GMT

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.

Re: VBA Code not copied in generated excel file

Fri, 25 Nov 2016 11:20:01 GMT

Super!

Many thanks Daniel.

Indeed I adjusted the output format and it worked.