topic Re: Macro not working in access point in QlikView

Macro not working in access point

bharatkishore — Thu, 13 Sep 2018 12:05:07 GMT

Hi All,

I have written the following macro.

Sub Info ()

msgText = "As communicated file is deleted."

Msgbox "Hello " & msgText

End Sub

This is working fine in server. But when i try to do in access point it is not working.

Note: testing in IE plugin and checked VB script and checked System Access and Allow system access. Using version 12.20 Sr1

Can you please tell me what i need to do..

Thanks,

Bharat

Re: Macro not working in access point

YoussefBelloum — Thu, 13 Sep 2018 12:45:31 GMT

Hi,

take a look at this:

https://community.qlik.com/message/584702?&_ga=2.180535143.1139363255.1536842696-833252679.1536842696#584702

Re: Macro not working in access point

bharatkishore — Thu, 13 Sep 2018 12:52:31 GMT

Hi,

Thanks for you reply. i have done all the steps but still it is not working..

Any suggestions..

Re: Macro not working in access point

YoussefBelloum — Thu, 13 Sep 2018 12:59:09 GMT

another useful link:

https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/UsingMacrosonQVS.htm

Re: Macro not working in access point

bharatkishore — Thu, 13 Sep 2018 13:07:09 GMT

Thank you.. But still i am facing this issue. Any suggestions why this might be happening .. And how to resolve..

Re: Macro not working in access point

Miguel_Angel_Baeyens — Thu, 13 Sep 2018 13:28:00 GMT

How is the macro triggered? Clicking on a button, activating a sheet, automatically?

MsgBox is a VB function which will not work with any browser which is not Internet Explorer. Make sure the QlikView server where the application resides is included in the trusted zones in the Internet Options and that the trusted zones permissions allow the execution of code.

Re: Macro not working in access point

bharatkishore — Fri, 14 Sep 2018 05:05:29 GMT

Hi Miguel,

Macro is triggered via document properties - on open trigger--external-- run macro.

So, now will the MsgBOX will not work in IE or any other browser.

Re: Macro not working in access point

Miguel_Angel_Baeyens — Fri, 14 Sep 2018 08:48:14 GMT

OnOpen will work. We have triggers working OK OnOpen, but they are using actions, not macros.

Instead of using the AccessPoint, open the document with QlikView Desktop > File > Open in Server and see if that makes any difference.

Next, using IE, install the QlikView Plugin for the version of QlikView Server you have installed, and try opening the document with it.

Next, add manually the site to the Trusted Sites list and try again.

If you already tried and it didn't work, I'd check with Qlik Support sending them a sample app so they can reproduce the same behavior you see.

Re: Macro not working in access point

bharatkishore — Fri, 14 Sep 2018 11:03:31 GMT

Thank you so much for your reply.. Will check all necessary things.