topic Re: Macro in Web server application in QlikView

Macro in Web server application

Mon, 12 Mar 2012 09:16:37 GMT

Hi,

I tried below macro code in my desktop application its working fine but when i used same macro code web server application the macro is not getting fired.

Sub ExportImageInfo

Set Chart = ActiveDocument.GetSheetObject("CH396")

Set P = Chart.GetProperties

Chart.SendToExcel

End Sub

Please can anyone suggest why it is creating problem and provide any solution to work this macro in web server application.

Thanks in advance.

Re: Macro in Web server application

bumin — Wed, 08 Jul 2015 08:20:29 GMT

This is the expected behavior with Ajax. If you use IE Plugin client - check QV Server settings, especially server security tab.

Re: Macro in Web server application

crusader_ — Wed, 08 Jul 2015 08:26:17 GMT

Hello,

To use VBScript macro you need to use IE plugin on your web-server instead of AJAX. Furthermore in some cases it works well with IE only.

Hope this helps you.

Regards,

Andrei

Re: Macro in Web server application

stigchel — Wed, 08 Jul 2015 08:34:11 GMT

In this case you could simply add the send to excel icon in the caption of the chart instead of the macro

Re: Macro in Web server application

bumin — Wed, 08 Jul 2015 08:40:24 GMT

I have installed IE Plugin,

and on the server all macro's are enabled.

The macro is still not starting.

do you have an idea what could it be the reason?

Re: Macro in Web server application

crusader_ — Wed, 08 Jul 2015 08:47:06 GMT

Bumin Kösesoy wrote:

I have installed IE Plugin,

and on the server all macro's are enabled.

Have you made changes on QVWS? I mean in the Access Point Setting "Default preferred Client"?

Regards,

Andrei

Re: Macro in Web server application

bumin — Wed, 08 Jul 2015 08:59:30 GMT

Hi Andrei,

these are my settings

Bumin

Re: Macro in Web server application

crusader_ — Wed, 08 Jul 2015 09:09:25 GMT

Hi Bumin,

Check below settings as well.

Hope this helps you.

Regards,

Andrei

Re: Macro in Web server application

bumin — Wed, 08 Jul 2015 09:43:34 GMT

checked

still no reaction (even not in Chrome)

Re: Macro in Web server application

crusader_ — Wed, 08 Jul 2015 09:59:30 GMT

If it even doesn't work in IE 9/10...

I don't have any ideas what could be the problem in your case.

Possibly the reason in macro code.

Try to exclude macro code itself... Write macro with simple msgBox or calculations without calling external objects.

Regards,

Andrei