topic Macro for NP Format Cleanup in Qlik NPrinting

Macro for NP Format Cleanup

cbaqir — Wed, 03 Jan 2018 15:43:28 GMT

Hi everyone,

Since NP doesn't support merging cells in Excel, I believe I need to use a macro to clean up formatting issues. I've never done this before but a quick Google search leads me to believe it's possible to do a Merge Across on EACH sheet in the workbook (except the first). A couple of questions since I have never done this if you will...

How do I get the macro to auto-run on every sheet other than the first? I don't want the end user to have to do anything.
I believe it will not run via the NP output but only once the user opens the file, correct?

Re: Macro for NP Format Cleanup

Chanty4u — Thu, 04 Jan 2018 12:32:19 GMT

you have to run the macro after generation of nprinting report.

you can write the macro code what ever the changes you have and run the macro

then if you have dot net team around they will schedule the report automatically

Re: Macro for NP Format Cleanup

Anonymous — Thu, 04 Jan 2018 14:46:22 GMT

Hi Cassandra,

please be aware that with Qlik NPrinting (Version 17) it is not possible to generate xlsm-reports. In the moment it is onlys possible to generate xlsx or xls.

With NP in Version 16 it should be possible.

Re: Macro for NP Format Cleanup

cbaqir — Thu, 04 Jan 2018 15:00:19 GMT

Wow. Another reason not to move to NP17! Thanks Tim.