topic Re: Running Macro Inside Template? in Qlik NPrinting

Running Macro Inside Template?

devarasu07 — Wed, 31 May 2017 07:36:22 GMT

I've created an Nprint Excel template with enabled macros and it should AutoRun every time the file is opened. However, when NPrinting is creating a report using this template, the macro does not run. But when I go to edit my template inside the report editor, the macro in the background runs without any problems. please refer to the attachment. kindly advise me. THanks

Re: Running Macro Inside Template?

woutermak — Wed, 31 May 2017 07:43:35 GMT

Isn't it the problem that in the publish task, or preview a .xlsx is used and not a xlsm file?

Only a xlsm can handle marco's

Re: Running Macro Inside Template?

Daniel_Jenkins — Wed, 31 May 2017 07:47:31 GMT

Hi Deva,

Since you are on version 16.x, take a look at this example: Index on page loop excel

HTH - Daniel.

Re: Running Macro Inside Template?

devarasu07 — Wed, 31 May 2017 08:30:05 GMT

Hi djk‌,

I've gone through your post and added below macro into your template after that when i preview the macro not auto running it? but if ran manually and it works . can u advise me. thanks in advance

Sub sbHello()

Range("A1").Value = Range("B9")

End Sub

THanks,

Deva

Re: Running Macro Inside Template?

Daniel_Jenkins — Wed, 31 May 2017 08:56:37 GMT

I don't see your macro in the template.

I tested my project again and it works just fine. Remember to Preview as Xlsm:

- Daniel.

Re: Running Macro Inside Template?

devarasu07 — Wed, 31 May 2017 09:28:56 GMT

Hi djk‌,

Working fine. Tks

Private Sub Workbook_Open()

Call sbHello

End Sub

Option Explicit

Sub sbHello()

Sheet2.Range("A1").Value = "hello"

End Sub