Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Are all of your users using the same client (IE Plugin or Ajax)?
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
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
Hi Colin
Yes they are all IE Plugin
Paul
Hi Marcus
The did ctrl+shift+m and "give system access to module script" was already ticked (as it is for me)
Paul
Hi Beck
They did ctrl+shift+m and "give system access to module script" was already ticked (as it is for me)
Paul
Yes Paul,
Try to activate it
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
Hi that did work after all - Many thanks for your help