Qlik Community

QlikView Management

Discussion Board for collaboration on QlikView Management.

Not applicable

Macro not running on server

Hi there,

I set up my QV document to mail reports when you press a button. You can enter the name of the report and an email address and after you press the button it mails the report. However when I put the document on the server the button won't work.

I checked if the settings on the server allowed execution of macro's and both 'allow macro execution' and 'allow unsafe macro execution' are checked. To verify that it would have nothing to do with the script I tried a simple document which shows a messagebox when you push the button but this also fails. Any suggestions?

Thank!

9 Replies
danielrozental
Honored Contributor II

Macro not running on server

Are you using Ajax or the IE Plugin? Check what the permission level for the document is if you press ctrl+shift+m.

Not applicable

Macro not running on server

I'm using the Ajax client. The permission levels are set to system access.

Not applicable

Macro not running on server

I've tried a simpeler macro and it appears that macro's are executed but there is a problem with pop ups and in this case the calling of the pdf printer.

Not applicable

Re: Macro not running on server

Hi Daniel Rozental

I am using IE plugins

DOCUMENTS:

- in Module: - Requested Module Security - System Access, Current Local Security -Allow System Access

- I did Cltr-Shift-M - Give System Acces to Module Script

SERVER:

- Setup - Security - Allow macro execution on server, Allow unsafe macro execution on server

but still my macro is not working on access point in production macro is working but in access point it is not working.

Please help me please....

Thanks in advance

Sher Bahadur

gainkarthi
Valued Contributor

Re: Macro not running on server

Macros will run only with IE plugin and not with Ajax clients.

If's it not working with IE plugin, you have to enable a option in MS Office features list.

Not applicable

Re: Macro not running on server

Hi  Karthikeyan Subramaniam

Thnaks for reply

I am using IE plugin and still it is not working so can you please give me some idea ? so I can enable the that option(please tell me the name of option which I have to enable).

One more thing Karthikeyan ,

I am simple created a macro and inside it I have given a msgbox("hello") but when I am firing macro from access point nothing is happening.

please help me.

Thanks Karthikeyan

gainkarthi
Valued Contributor

Re: Macro not running on server

Please try enabling VBA component in MS-Office.

gainkarthi
Valued Contributor

Re: Macro not running on server

Not applicable

Re: Macro not running on server

Thanks for reply  Karthikeyan

I have enabled the VBA component but still it is not working on the server.

and also I have created a macro and want to open a pop-up msgbox which print simple ("hello") and this is also not opening.

please help me .

Community Browser