topic Re: Exporting QV objects to a Excel document using macros? in QlikView

Exporting QV objects to a Excel document using macros?

devarasu07 — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

Macros working fine with Qlikview desktop but it's not working browser (IE plug in / AJAX client). is there workaround solution for this?

I've enabled macros at server level and script (please refer to the attached document and screen shot). please advise? Thanks

Environment:

Qlikview 11.20.12904.0409.10 & Windows 2012 R2

Thanks

Deva

Re: Exporting QV objects to a Excel document using macros?

marcus_sommer — Tue, 03 Jan 2017 11:24:00 GMT

It won't work with the AJAX-client but it should work with the IE-plugin. What happens by using the plugin - nothing? Then check the user-settings for qlik macro-execution and the IE configurations, especially the "protected mode" and the ActiveX settings.

- Marcus

Re: Exporting QV objects to a Excel document using macros?

devarasu07 — Tue, 03 Jan 2017 12:10:26 GMT

Hi marcus_sommer,

Thanks for your kind reply, when i use IE-Plugin nothing happens. think i missed some step,

steps which did,

1) downloaded IE plugin from access point browser

2) then installed(IE plugin) into my local machine

3) after than tried to login access point through IE browser (my IE current version : 11) and then tried to click on macros enabled button (sample attached screen shot) -

4) after clicking export to excel (macro configured button) nothing happens

am i missed any steps? kindly advise (i suspect my ie browser - access point url still using ajax)

Thanks

Deva

Re: Exporting QV objects to a Excel document using macros?

Miguel_Angel_Baeyens — Tue, 03 Jan 2017 12:14:35 GMT

You still are opening the document with the Ajax client. In the AccessPoint, click on "View Details" and then "IE Plugin version".

However, note that if you develop macros only to work with IE, you need to make sure all users are browsing QlikView using IE AND that they have local admin permissions to install the Plugin.

Re: Exporting QV objects to a Excel document using macros?

devarasu07 — Tue, 03 Jan 2017 12:41:17 GMT

Hi Miguel

Noted, i have tried to enabled IE profile like below then

after than tried to open it, getting like below? do i need to do any other setting?

User Requirement:

Export entire dashboard tab into excel? after they logged into Access point they just want to click on one button and then it should be able to export all sheet objects into excel (let's say the sheet object contains graph/image and table view). Currently it works only with individual object to export (by default).

Just wanted to check, do we have any other method to fulfill my requirement other than macros?

Thanks

Deva

Re: Exporting QV objects to a Excel document using macros?

marcus_sommer — Tue, 03 Jan 2017 12:51:54 GMT

Your application will be only opened with the preferred client if this client is enabled for these application within the qmc by documents/server/availability.

- Marcus

Re: Exporting QV objects to a Excel document using macros?

devarasu07 — Tue, 03 Jan 2017 12:59:03 GMT

Hi @Marcus,

Yeah, it's configured already (both places user & source document place). after enable this step then published again and tested and still getting same message (refer 2nd screen shot). thank you much

Re: Exporting QV objects to a Excel document using macros?

marcus_sommer — Tue, 03 Jan 2017 13:07:49 GMT

Please check if there is anywhere a small dialog-window from qlikview for setting the macro-security for this application respectively all applications. This window could be hidden under other windows and also be on another monitor (by using multiple monitors). For this check per pressing the keys Alt + Tab or by minimizing all open windows step by step.

- Marcus

Re: Exporting QV objects to a Excel document using macros?

devarasu07 — Tue, 03 Jan 2017 13:54:52 GMT

Hi marcus_sommer‌,

Thanks for your reply, not getting the above mentioned step? by the way is there any document available? (tried to searched in qlik support portal and internet and couldn't able to find). if you have anything please share it. thanks

additionally enabled below steps and re-published then tested and still not working? any suggestion. tks

Re: Exporting QV objects to a Excel document using macros?

marcus_sommer — Tue, 03 Jan 2017 14:42:58 GMT

It looked that your application wouldn't be opened with the IE plugin. Like above mentioned there might be an unvisible dialog-window from the plugin asking for an action. To make further checks I suggest to create another dummy-application without any macros and enabling for it the plugin, too, to see if it will be opened.

- Marcus

Re: Exporting QV objects to a Excel document using macros?

devarasu07 — Tue, 03 Jan 2017 15:08:59 GMT

Hi Marcus,

Now able to open the document through IE plug in but when i click the button (Export to excel) nothing happens.

"xxx.qvw is being opened" issue resolved.

Thanks

Deva

Re: Exporting QV objects to a Excel document using macros?

marcus_sommer — Tue, 03 Jan 2017 15:33:42 GMT

If you have opened the export-application press Ctrl+Shift+M - then you will get access to the macro security-options and there you need to enable system/file-access. Further go to IE options and disable the protected mode and take a look to the various ActiveX options - they needs to be enabled too. If they are not available - those options might be restricted through your IT department - you could try to move the access point to the trusted websites.

- Marcus

Re: Exporting QV objects to a Excel document using macros?

devarasu07 — Tue, 03 Jan 2017 15:46:27 GMT

Hi marcus_sommer‌

Thanks for your reply, when I selected Ctrl+Shift+M, Give System Access to Module Script" is chosen. and also enabled trusted websites . (do we have any server level/browser level log file it will be useful for debugging the issue)

Re: Exporting QV objects to a Excel document using macros?

marcus_sommer — Tue, 03 Jan 2017 15:52:26 GMT

You need also to disable the protected mode:

- Marcus

Re: Exporting QV objects to a Excel document using macros?

devarasu07 — Tue, 03 Jan 2017 16:07:40 GMT

Hi @Marcus,

disabled the protected mode option and the clear all my browser history and then re-opened and still nothing happens when i clicks on "Export to Excel" button. tks deva

Re: Exporting QV objects to a Excel document using macros?

marcus_sommer — Tue, 03 Jan 2017 16:12:02 GMT

Try again with a dummy-app with a simple macro like: msgbox "Hello World" to check if any macro will be executed.

- Marcus

Re: Exporting QV objects to a Excel document using macros?

devarasu07 — Tue, 03 Jan 2017 17:01:41 GMT

Hi Marcus,

Please refer to the attachment, tried with your suggestion and simple Hello world macro program also not working. Thanks Deva

Re: Exporting QV objects to a Excel document using macros?

marcus_sommer — Wed, 04 Jan 2017 08:21:39 GMT

For me it worked without any problem:

Take again a look on all above mentioned settings if there is anything noticeable.

Another potential problems could happens if there are any proxy-servers within the IE connection-settings. Further there could be some incompatibility between your server + plugin release and the IE release - one possibility here might be to use the compatibility-mode from the IE to use an older release maybe the IE8.

- Marcus