topic Macro Export to Excel not working on browser in QlikView

Macro Export to Excel not working on browser

Thu, 05 May 2016 09:32:46 GMT

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.

Re: Macro Export to Excel not working on browser

Gysbert_Wassenaar — Fri, 06 May 2016 08:27:09 GMT

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

Re: Macro Export to Excel not working on browser

Fri, 06 May 2016 08:50:19 GMT

yes in my code i have Ecxel.Application

Re: Macro Export to Excel not working on browser

Gysbert_Wassenaar — Fri, 06 May 2016 15:34:48 GMT

Change Ecxel.Application to Excel.Application.

Re: Macro Export to Excel not working on browser

Fri, 06 May 2016 15:36:27 GMT

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.

Re: Macro Export to Excel not working on browser

trdandamudi — Fri, 06 May 2016 15:38:53 GMT

It is not

Ecxel.Application

Please change that to : Excel.Application

Re: Macro Export to Excel not working on browser

Gysbert_Wassenaar — Fri, 06 May 2016 16:24:03 GMT

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.

Re: Macro Export to Excel not working on browser

jrdunson — Thu, 13 Apr 2017 13:55:26 GMT

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?

Re: Macro Export to Excel not working on browser

krishnacbe — Thu, 13 Apr 2017 14:22:06 GMT

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,

Re: Macro Export to Excel not working on browser

jrdunson — Thu, 13 Apr 2017 14:34:16 GMT

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?