NPrinting - Developer ribbon in Excel / Template Editor

[markiskander]

Is there a way to show the Developer ribbon in Excel / Designer / Template Editor?  Looking to use VBA to develop one of our reports.

[Lech_Miszkiewicz]

Regardless of the fact if can or cannot have developer ribbon in NPrinting… why dont you develop your vb script, store template file as xlsm and the use it as a template when creating report?

that is the typical way you would do things in NPrinting anyway due to fact that in order to have xlsm template you will need to load it first

[Ruggero_Piccoli]

Hi,

Please remember to add the label with the correct version of Qlik NPrinting you are using. 

You have to follow the instructions posted by @Lech_Miszkiewicz because creating an .xlsm file and upload it as a custom template is the only way to create an .xlsm template otherwise it will be created as .xlsx and it cannot include VBA code. 

Also, note that macros are only copied to the generated templates and never executed by Qlik NPrinting.

Best Regards,

Ruggero

[markiskander]

Thanks Lech_Miszkiewicz and Ruggero.  I'm obviously new to Qlik, apologies for the beginner questions.

Ruggero - you mention that macros are only copied to the generated templates and never executed by Qlik NPrinting.  We intend to have these reports auto-emailed to managers, ideally in their...'post-macro-executed' state.  Pretty sure this is a dumb question, but how can we do this if the macros can't be executed prior to the reports being emailed out?   How do we get the macros to execute prior to them being emailed/received?

Thanks again for the responses, much appreciated.

[David_Friend]

@markiskander what version of NPrinting and version of QlikSense?

Also watch this youtube video, it may help: https://www.youtube.com/watch?v=VIq_MtTpBL8

[markiskander]

We're on QlikSenseServer 14.54.2, and NPrinting Version 21.14.7.0

And now i'm somehow seeing the Developer tab.

The video is just what i needed - many thanks.

[David_Friend · Accepted solution]

@markiskander cool please do me a favor and click on 'Accept As Solution' thanks!

[Lech_Miszkiewicz]

Hi @markiskander 

No, you will not have these reports auto-emailed to managers in their...'post-macro-executed' state as NPrinting will not execute macros-full stop. Your macro can only be triggered by end user (manager) opening the document and this is design of NPrinting at the moment. 

Obviously you can workaround it by producing reports to a folder and having a batch process triggering your macros and saving document then distributing it outside of NPrinting. This process is obviously much more convoluted and hard to do and is having nothing to do with NPrinting anymore.

Question really is: why do you need to have a macro in your report in first place. Maybe there is a solution which will not require it?

cheers