VBA and Nprinting

[Dabad]

Hello everyone ,

I'd like first, to thank everyone, who would take time to read this questions, and reply to it.

I'm trying to add a VBA macro, to an nprinting report( Excel report that contains many sheets), in order to hide a sheet if it empty.

I'm finding a hard time, including the code in Nprinting, each time i copy it and try to register it, i receive this error message :

 

Thank you in advance,

Ps : i  have the june 2019 version of nprinting,

and here is the code i'm trying to implement :

Private Sub Worksheet_Change(ByVal Target As Range)
If Not IsEmpty("Sheet 1[G:G]") Then
Sheets("Sheet1").Visible = True
Else
Sheets("Sheet1").Visible = False
End If
End Sub

[Lech_Miszkiewicz]

how about if you create a xlsm file first with your script and then load it as a template. I assume the problem is that you are creating xlsx template and try to embed vb script in it which is not supported.

[Dabad]

Thank you for your reply,

[Lech_Miszkiewicz]

Does this solve your problem?

[Ruggero_Piccoli]

Hi,

I agree with @Lech_Miszkiewicz , you must create and .xlsm template and generate .xlsm report.

Please note that:

• the .xlsm format is supported since September 2018. Older versions don't support it.
• Qlik NPrinting 17+ supports only Excel macros. Word and PowerPoint macros are not supported
• For safety reasons, VBA code is never executed by Qlik NPrinting, it is only copied from the template to the generated report. It is up to you to create, for example, an event based execution or add a button, etc
• As consequence of previous point, Excel reports with VBA created in PDF format will don't show the macro executed

Best Regards,

Ruggero