Solved: is it possible to add VBA Code in excel Nprirnting - Qlik Community

Qlikuser09 · ‎2023-11-01

VBA code in Excel npriting

Lech_Miszkiewicz · ‎2023-11-02

Yes.

you can follow those steps: https://www.youtube.com/watch?v=VIq_MtTpBL8

note that the macro will have to be executed on recipient machines (not when generating report)

cheers

More info here: https://help.qlik.com/en-US/nprinting/May2023/Content/NPrinting/ExcelReports/Intro-Excel.htm

cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.

View solution in original post

Ruggero_Piccoli · ‎2023-11-02

Hi,

Remember that:

Qlik NPrinting just copy the VBA code from the template to the generated reports but never executes it
You have to create an .xlsm custom template file, upload it at the beginning of the template creation and set .xlsm as output format. Using .xlsx in one of the two steps will result in no VBA code in the generated reports

Best Regards,

Ruggero

Best Regards,
Ruggero
---------------------------------------------
When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads with a LIKE if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads with LIKEs if you feel additional info is useful to others.