Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Macro Export to Excel not working on browser

Hi everybody,

I have a Qlikview App that holds a macro for exporting to excel, the button work fine in the desktop and after deploying the app in the server , the button work for some final users (who have windows 7) and do not work for others (who have windows 10)

What i did is :

1) install internet explorer plugin

2) under "Favorites & Profile" in access point i changed Preferred client to internet explorer plugin

3) deactivate protected mode in internet explorer

4) deactivate protected mode in Excel

5) On "Edit Module", in "Current Local Security" i set it to allow System Access.

Im using internet explorer 11

For some users who have windows 10 i have this error:

Un composant ActiveX ne peut pas créer un objet : 'Ecxel.Application


Thank You.

9 Replies
Gysbert_Wassenaar

Check your code. Ecxel.Application -> Excel.Application


talk is cheap, supply exceeds demand
Not applicable
Author

yes in my code i have Ecxel.Application

Gysbert_Wassenaar

Change Ecxel.Application to Excel.Application.


talk is cheap, supply exceeds demand
Not applicable
Author

sorry i want o say i have Excel.Application in my code.

i think the code is correct since it works in desktop and in browser for some users.

trdandamudi
Master II
Master II

It is not

Ecxel.Application

Please change that to : Excel.Application

Gysbert_Wassenaar

Then the problem is not Qlikview or the Qlikview Plugin, but your Windows 10 security settings. Ask your local friendly system administrator to help you sort this out.


talk is cheap, supply exceeds demand
jrdunson
Creator
Creator

Hey sorry for the late entry...but this morning, a Windows 10 user could not export via the Excel button on a QV table...(nor scroll down on QV tables) .  What are the security settings that need updating?

krishnacbe
Partner - Specialist III
Partner - Specialist III

Hi,

Check whether the users for whom it is not working are trying to access in Ajax client.

As Macro will not work in Ajax client, ask them to try in IE Plugin,

jrdunson
Creator
Creator

Krishnapriya

Hey, I have some users who can work fine with Windows 10, the Ajax client, through Chrome... I have another user who can't...and am trying to check the user's setting [It might be the DDE setting? In Excel: Options -> Advanced -> General -> uncheck 'Ignore DDE Connections'   ... I don't know yet]

Are there other security/setup issued for Windows 10 I need to think about?