Macro parse failed: Functionality was lost

[paul_ripley]

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

[Colin-Albert]

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

[marcus_sommer]

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

[beck_bakytbek · Accepted solution]

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

[paul_ripley]

Hi Colin

Yes they are all IE Plugin

Paul

[paul_ripley]

Hi Marcus

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

Paul

[paul_ripley]

Hi Beck

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

Paul

[beck_bakytbek]

Yes Paul,

Try to activate it

[marcus_sommer]

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

[paul_ripley]

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