Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
This is the expected behavior with Ajax. If you use IE Plugin client - check QV Server settings, especially server security tab.
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
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
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?
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
Hi Andrei,
these are my settings
Bumin
Hi Bumin,
Check below settings as well.
Hope this helps you.
Regards,
Andrei
checked
still no reaction (even not in Chrome)
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