Discussion Board for collaboration related to QlikView App Development.
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?
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).
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.