topic Re: Run Macros in QV document from Management console? in QlikView

Run Macros in QV document from Management console?

Mon, 26 Jan 2026 18:19:17 GMT

Hi,

I have some PostReload macros I'm running.

The issue is that when I reload the model from the management console, the macro isn't activated.

is there a way to override it?

Thanks,

Boris

Re: Run Macros in QV document from Management console?

awhitfield — Wed, 18 Mar 2015 15:51:42 GMT

Hi Boris,

the control settings for this are in QMC: System>Setup>QVSERVER> Security tab

Regards

Andy

Re: Run Macros in QV document from Management console?

buzzy996 — Wed, 18 Mar 2015 16:03:27 GMT

try the above suggested solution.

Re: Run Macros in QV document from Management console?

Wed, 18 Mar 2015 17:33:59 GMT

Didn't help.

Also checked the unsafe macros.

it works when I run it manually from the modeler but not with QMC execution.

This is the macro:

SUB ExportChartToCSV

SET objChart = ActiveDocument.GetSheetObject("BorisTest")

objChart.Export "C:\Data.CSV", ", "

END SUB

it exports 1 chart.

Re: Run Macros in QV document from Management console?

buzzy996 — Wed, 18 Mar 2015 17:37:47 GMT

C drive is mapped with ur server? else u can place ur CSV file whichever the drive mapped with ur server and try.

Re: Run Macros in QV document from Management console?

Wed, 18 Mar 2015 17:48:49 GMT

Tried to change drives.

didn't help.

it works manually from the modeler with regular reload, but not by using the reload from QMC.

Re: Run Macros in QV document from Management console?

buzzy996 — Wed, 18 Mar 2015 17:56:57 GMT

from the above image, there is check box Allow unsafe macro execution on server? pls select & save ....try!

Re: Run Macros in QV document from Management console?

Wed, 18 Mar 2015 18:36:41 GMT

unfortunately, you can see in my first comment that I already did it...

Do you have a server to try a sample that I'll send you?

Re: Run Macros in QV document from Management console?

Thu, 19 Mar 2015 07:10:36 GMT

Tried it all, even allowing acces to system from Macro VB script editor.

I created a button to execute the same macro, it works from access point but doesn't work from QMC task console reload.

might it be that the only possible way to execute it is through creating a batch file that reloads the model?

Thanks,

Boris

Re: Run Macros in QV document from Management console?

awhitfield — Thu, 19 Mar 2015 08:59:29 GMT

Hi Boris,

apparently you can't get a QMC to execute a macro, you need to run it from a .bat file, executed from Windows scheduler, see the following thread: http://community.qlik.com/thread/115808

Re: Run Macros in QV document from Management console?

jonathandienst — Thu, 19 Mar 2015 09:15:34 GMT

The OnPostReload event is not fired after a server reload. You will need to use a batch load using QV desktop to perform the reload.

HTH

Jonathan

Re: Run Macros in QV document from Management console?

luciancotea — Thu, 19 Mar 2015 09:19:17 GMT

The OnPostReload event is not fired after a server reload. You will need to use a batch load using QV desktop to perform the reload.

This is the correct answer. Server CAN execute macros. The problem is with the trigger.