topic Re: Macro parse failed: Functionality was lost in QlikView

Macro parse failed: Functionality was lost

paul_ripley — Fri, 19 Aug 2016 10:33:41 GMT

Hello

We have a macro that exports objects to Excel. We run it from the access point. It works for a group of users but for others they get the message

Macro parse failed: Functionality was lost

exportToExcel_variant3 (which is the macro name)

Error: ActiveX component cant create object. 'Excel.Application'

The users have allowed macros, so I don't think this is the reason.

It works for me but I am an admin on the server (as I think the others users are who can run the macro - could just be a coincidence?)

Does anyone have any idea if there is an IE setting controlling this?

Thanks

Paul

Re: Macro parse failed: Functionality was lost

Colin-Albert — Fri, 19 Aug 2016 10:41:20 GMT

Are all of your users using the same client (IE Plugin or Ajax)?

Re: Macro parse failed: Functionality was lost

marcus_sommer — Fri, 19 Aug 2016 10:50:55 GMT

This error meant that ActiveX isn't enabled and/or that the users didn't allow the macro system-access (could be changed within the settings.ini from each user or within the gui per pressing ctrl+shift+m and choosing there the third option).

- Marcus

Re: Macro parse failed: Functionality was lost

beck_bakytbek — Fri, 19 Aug 2016 11:07:58 GMT

Hi Paul,

try this : Ctrl+Shift+M and then Check: Give System Access to Module Script

let me know if you solve your issue

i hope that helps

Re: Macro parse failed: Functionality was lost

paul_ripley — Fri, 19 Aug 2016 11:13:28 GMT

Hi Colin

Yes they are all IE Plugin

Paul

Re: Macro parse failed: Functionality was lost

paul_ripley — Fri, 19 Aug 2016 11:15:41 GMT

Hi Marcus

The did ctrl+shift+m and "give system access to module script" was already ticked (as it is for me)

Paul

Re: Macro parse failed: Functionality was lost

paul_ripley — Fri, 19 Aug 2016 11:16:18 GMT

Hi Beck

They did ctrl+shift+m and "give system access to module script" was already ticked (as it is for me)

Paul

Re: Macro parse failed: Functionality was lost

beck_bakytbek — Fri, 19 Aug 2016 11:20:30 GMT

Yes Paul,

Try to activate it

Re: Macro parse failed: Functionality was lost

marcus_sommer — Fri, 19 Aug 2016 11:20:51 GMT

Then ActiveX is disabled on the user-side. This could be done directly through the various ActiveX settings or through more global settings like using the protected mode or using of a high security-level and didn't add the access point to the trusted sites or something similar.

- Marcus

Re: Macro parse failed: Functionality was lost

paul_ripley — Fri, 19 Aug 2016 11:31:29 GMT

Hi that did work after all - Many thanks for your help

Re: Macro parse failed: Functionality was lost

paul_ripley — Fri, 19 Aug 2016 11:32:38 GMT

Hi Marcus

Actually ctrl-shitft-m did work and change the macro settings

Thanks

Paul

Re: Macro parse failed: Functionality was lost

beck_bakytbek — Fri, 19 Aug 2016 11:32:57 GMT

you are welcome,

learning by doing

Re: Macro parse failed: Functionality was lost

athompsonhp — Fri, 26 Aug 2016 13:48:06 GMT

I am running into the same issue. I followed your discussion thread and there seems to be something missing.

"Try to activate it" then you responded "Hi that did work after all - Many thanks for your help". Can you shed some light on the steps that you took? Thanks.

Re: Macro parse failed: Functionality was lost

paul_ripley — Fri, 26 Aug 2016 13:55:06 GMT

Hi Andy

I just went over to the users computer, and asked her to do ctrl-shift-m. Then got her to click 'Give system access to module script' the 'OK'

And this worked for her

Paul