Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

holynumbers
New Contributor II

Nprinting 17.2.3 How to create a XLSM

Hi,

I've used a .xlsm template when creating the report, but I can't preview it as a xlsm (the option doesn't exist) and I'm not available to select this format as a task either.

What should I do?

I really want to use slicers in my file, but I think I need a .xlsm file for that to work properly. It cant use slicers in .xlsx previews or exports....

/John

Tags (3)
5 Replies
woutermak
Contributor III

Re: Nprinting 17.2.3 How to create a XLSM

Hi,

You can’t use the macro functionality in the nprinting designer or preview. But you can use a template with macro functionality.
You can distribute your Excel with full functionalities.

Wouter

holynumbers
New Contributor II

Re: Nprinting 17.2.3 How to create a XLSM

Hi,

That doesn't work.

Even if the template I use is a .xlsm the export is a .xlsx and there is no macro code in the file.

cristinapo
New Contributor III

Re: Nprinting 17.2.3 How to create a XLSM

I'm dealing with this same issue.

I'm curious if anyone has any workaround.

Employee
Employee

Re: Nprinting 17.2.3 How to create a XLSM

Hi,

at the moment (stable version is September 2017) XLSM (and all other types of Office documents with macros) is not supported by Qlik NPrinting 17.*. For example you cannot set XLSM as output format of a generated report.

Qlik NPrinting 16.* supports Office macros, so you can create a template in XLSM format and set XLSM as output format. Qlik NPrinting 16.* NEVER executes the VBA code of macros while creating the final reports for security reasons. Qlik NPrinting 16.* just copys the VBA code from the XLSM template to the XLSM generated report. When the user opens the report he can run the macros or you can associate them with the opening event.

We don't know when when this gap between 16 and 17 will be filled.

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 as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.



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.
Employee
Employee

Re: Nprinting 17.2.3 How to create a XLSM

.xlsm as an output will be part of the September 2018 release

Community Browser