Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Macros are not working in accesspoint(IIS)

Hi,

i have a qvw file, it's working fine in the QlikView Personal Edition.

but if i place the same file in the QlikView Server (AccessPoint), it is not working properly.

Functionality of the macro is copying chart data and create a excel with this data in specified path location in same machine.

the Macro is not working properly. what could be the issue?

so what we have to do this?

Thanks,

Sahithya

24 Replies
Not applicable
Author

When I open my accesspoint from IE I am getting "Download Internet Explorer Plugin"  at the top.I downloaded, I got file "QvPluginSetup" and installed in the server. Still same issue. Macros are not working.

Not applicable
Author

When I open my accesspoint from IE I am getting "Download Internet Explorer Plugin"  at the top.I downloaded, I got file "QvPluginSetup" and installed in the server. Still same issue. Macros are not working.

Not applicable
Author

you also have to mak sure that your document is being opened with it dont press directly on the document. click on view details and there you should see IE Plugin. click on it and the document will be opend with IE plugin and you macros should work.

regards,MT

Not applicable
Author

Macro is running.
My macro is relating to copying chart data into excel.

In macro I wrote as

 

Set objExcel = CreateObject("Excel.Application")

Will this works in IE plugin.

Not applicable
Author

Macro.JPG

This is the issue what I am getting.

Not applicable
Author

ok this could be two reasons eiter the macros are blocked from IE you can check it out with crtl-shift-M

or in the macro editor on the left side you can set the security properties.

I hope it helps.

regards,

MT

Not applicable
Author

Hi,

U mentioned as click on view details and there you should see IE Plugin. click on it and the document will be opend with IE plugin and you macros should work.

When I clicked on "View details" and selected "IE plugin", my dashbaord is not opened. Showed error as below;

image.JPG

Not applicable
Author

Hi Magdalena,

I checked in Ctrl+Shift+M .

image.JPG

Can anyone tell me solution ASAP.


Not applicable
Author


Hi Magdalena,

Can you please reply me how to get amcros worked in accesspoint. PLease spare some of your precious time on this.

Not applicable
Author

I was out of office so no time to do this.

I added a pic where you can see what you have to change in the editor for macros. you have to change it to acces to external data. and the properties in Internet Explorer looks fine to me.

and dont forget to open the qvw with the IE Plugin.

regards,

MT