Export macro does not work on Access Point

[#1]

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

[ashfaq_haseeb]

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

[fkeuroglian]

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

[#4]

Hi Fernando,

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

Thanks

[fkeuroglian · Accepted solution]

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

[#6]

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

[Anonymous]

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?

[#8]

Hi Fernado.. Thanks a lot for ur suggestion.

Now it is working for me!

[#9]

Hi Ashfaq,

Thanks a lot for ur suggestion:

It worked.

[fkeuroglian]

Excellent!

good job!

Fernando