Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

Not applicable

VBA Code not copied in generated excel file

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

Tags (4)
1 Solution

Accepted Solutions
djk
Valued Contributor III

Re: VBA Code not copied in generated excel file

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.

3 Replies
MVP
MVP

Re: VBA Code not copied in generated excel file

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

djk
Valued Contributor III

Re: VBA Code not copied in generated excel file

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.

Not applicable

Re: VBA Code not copied in generated excel file

Super!

Many thanks Daniel.

Indeed I adjusted the output format and it worked.

Community Browser