topic Re: Macros failed on access point? in QlikView

Macros failed on access point?

qlikuser222 — Thu, 19 May 2016 13:53:17 GMT

Hi,

I have macros for export to excel, it works good on my desktop when i allow system access, but on access point it is not working.

It shows below error.

Can anyone please help me to solve this.

Thanks

jerrysvensson — Thu, 19 May 2016 13:58:55 GMT

Does the user have Excel installed?

You have to use Plugin as client to get this to work. WebView (Ajax) doesn't work.

qlikuser222 — Thu, 19 May 2016 14:00:14 GMT

Thanks for reply,

Yes, User has excel installed, and using ie plugin

marcus_sommer — Thu, 19 May 2016 14:32:40 GMT

Within the modul security (left side of modul editor) you need to enable system access to create an excel-application.

- Marcus

tamilarasu — Thu, 19 May 2016 14:34:31 GMT

Nicholas,

Go to editor window and select the security level that’s required: “System Access” and “Allow Access System”.

qlikuser222 — Thu, 19 May 2016 15:09:03 GMT

I did that and its working good on desktop, but not on access point.

Thanks

qlikuser222 — Thu, 19 May 2016 15:09:11 GMT

I did that and its working good on desktop, but not on access point.

Thanks

tamilarasu — Thu, 19 May 2016 15:48:44 GMT

Check below link. Make sure all the suggestions are done from your side.

jerrysvensson — Fri, 20 May 2016 07:39:33 GMT

When you opened the app the first time, did you get a dialog saying something about security?

If so did you check the third one (bottom)?