Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'm trying to create VBA scripts for an excel report in the report designer but i can't save the template with the scripts.
What I have tried.
allowed all macros in the trust center.
Version: NPrinting report designer september 2020.
Also even if i get the VBA to run in the designer will qlik actually run the code every time the report gets generated?
i'm seeing alot of inconclusive answers in the documentation.
Hi, so yeah - it is quite straight forward and few things need to be taken into account. First of all none of the macros will be executed when NPrinitng produces report. Macros should be written so they are executed on document open on end users PCs.
Now with this aside the steps are:
Never worked with NPrinting but you may need to change the filetype from xlsx to xlsm because xlsx couldn't save macros. I don't know if it's customizable anywhere ...
- Marcus
@Lech_Miszkiewicz may be able to help on this!
Hi, so yeah - it is quite straight forward and few things need to be taken into account. First of all none of the macros will be executed when NPrinitng produces report. Macros should be written so they are executed on document open on end users PCs.
Now with this aside the steps are: