Use VBA Macro in Nprinting
Nprinting can use VBA macro in the excel report like normal excel report.
Only thing that you need to pay attention is the format of the template and the output file.
If the report template you are using is not .xlsm format, you can save it as .xlsm format. Or if you add macro in a non-xlsm format file, when you save it, you will got notification and then can save the file to .xlsm format.
In order to change the output file format in nprinting, you can open the task>reports, then there is a list of the reports that used in the task. There is a column called "Output Format" where identify the format of the output of the report, then you can modify it to .xlsm.
Only thing that you need to pay attention is the format of the template and the output file.
If the report template you are using is not .xlsm format, you can save it as .xlsm format. Or if you add macro in a non-xlsm format file, when you save it, you will got notification and then can save the file to .xlsm format.
In order to change the output file format in nprinting, you can open the task>reports, then there is a list of the reports that used in the task. There is a column called "Output Format" where identify the format of the output of the report, then you can modify it to .xlsm.
you just explained the Output Format that I couldn't find in the Qlik forums. Thanks!
ReplyDelete