topic Re: VBA and Nprinting in Qlik NPrinting

VBA and Nprinting

Dabad — Mon, 30 Sep 2019 09:50:47 GMT

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

Re: VBA and Nprinting

Lech_Miszkiewicz — Mon, 30 Sep 2019 10:26:34 GMT

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.

Re: VBA and Nprinting

Dabad — Mon, 30 Sep 2019 11:11:29 GMT

Thank you for your reply,

Re: VBA and Nprinting

Lech_Miszkiewicz — Mon, 30 Sep 2019 11:14:35 GMT

Does this solve your problem?

Re: VBA and Nprinting

Ruggero_Piccoli — Mon, 30 Sep 2019 13:09:34 GMT

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