topic Export macro does not work on Access Point in QlikView

Export macro does not work on Access Point

Wed, 12 Nov 2014 18:02:20 GMT

Hi All,

we have a small application in which we created a button and applied macro to export the straight table data to an excel sheet. it all fine on desktop.

when i open the same document on access point, Export button does not work.

the path for the Excel destination after export is C:\Temp\test.xlsx. we are Using Qlikview 11.20 (IE plugin is installed by default???).

i have read lot of posts in the community and tried few things like provided system access to Macro, IE settings etc..

but nothing worked for me.

Can someone please suggest what should be done to achieve this task?

and also, when i give the path as C:\Temp\test.xlsx, does it get stored on server folder or local desktop folder?

I am new to qlikview.. so please help..

Thanks

Jyothi

Re: Export macro does not work on Access Point

ashfaq_haseeb — Wed, 12 Nov 2014 18:04:31 GMT

Hi,

Not all macro works on server.

You can try by using pluggin instead of Ajax client.

Let me know if that worked.

Regards

ASHFAQ

Re: Export macro does not work on Access Point

fkeuroglian — Wed, 12 Nov 2014 19:34:07 GMT

Hi, try to install IEPlugin to run the macro to export, you will have to install local in each machine that you want to export

good luck

Fernando

Re: Export macro does not work on Access Point

Wed, 12 Nov 2014 19:37:06 GMT

Hi Fernando,

I searched in the community for the download link. but i dint find any.

Thanks

Re: Re: Export macro does not work on Access Point

fkeuroglian — Wed, 12 Nov 2014 19:45:42 GMT

See the attached, you can acces to your server in the acces point and download

then install and do "RUN AS ADMINISTRATOR"

good luck

Fernando

Re: Export macro does not work on Access Point

Wed, 12 Nov 2014 20:21:27 GMT

Thanks a lot Fernando. I will try this right away.

Re: Export macro does not work on Access Point

Anonymous — Wed, 12 Nov 2014 21:22:04 GMT

Is it possible that when you run it on the Access Point, that because it is running in the context of the server that it is now trying to put the excel sheet on the C drive of the server?

Re: Export macro does not work on Access Point

Wed, 12 Nov 2014 23:58:21 GMT

Hi Fernado.. Thanks a lot for ur suggestion.

Now it is working for me!

Re: Export macro does not work on Access Point

Thu, 13 Nov 2014 00:01:00 GMT

Hi Ashfaq,

Thanks a lot for ur suggestion:

It worked.

Re: Export macro does not work on Access Point

fkeuroglian — Thu, 13 Nov 2014 00:06:24 GMT

Excellent!

good job!

Fernando

Re: Export macro does not work on Access Point

Thu, 13 Nov 2014 01:22:51 GMT

Hi Steve,

i had given folder path as C:\Temp\

and when i run it on access point, it gets stored on the local desktop not on server.

Re: Export macro does not work on Access Point

ashfaq_haseeb — Thu, 13 Nov 2014 03:02:06 GMT

Good to know it woked.

Regards

ASHFAQ