Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
Support
Support

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.

View solution in original post

3 Replies
Highlighted
MVP & Luminary
MVP & Luminary

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

Highlighted
Support
Support

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.

View solution in original post

Highlighted
Not applicable

Re: VBA Code not copied in generated excel file

Super!

Many thanks Daniel.

Indeed I adjusted the output format and it worked.