Macro in Web server application

[#1]

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.

[bumin]

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

[crusader_]

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

[stigchel]

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

See also this article

Macros are Bad

[bumin]

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?

[crusader_]

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

[bumin]

Hi Andrei,

these are my settings

Bumin

[crusader_]

Hi Bumin,

Check below settings as well.

Hope this helps you.

Regards,

Andrei

[bumin]

checked

still no reaction (even not in Chrome)

[crusader_]

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