topic Re: Help - Send to Excel error in QlikView

Help - Send to Excel error

Thu, 01 Nov 2012 20:23:48 GMT

I am trying to send information from qlikview to excel but when I right click export to excel it does nothing. Everyone else in my department is able to do this.

I have tried going into internet options however i don't have administrator rights.

Re: Help - Send to Excel error

MayilVahanan — Thu, 01 Nov 2012 20:39:33 GMT

Try like this

In macro:

Button action:

Macro -> exporttoxls

sub exporttoxls

set obj = ActiveDocument.GetSheetObject("CH01")

obj.ExportBiff "C:\test.xls"

end sub

And noticed in c folder. Whether there is test file or not?

Let us know ,its working or not..

For keep the xls functionality in chart itself, please refer the attached image.

Re: Help - Send to Excel error

phaneendra_kunc — Thu, 01 Nov 2012 22:06:21 GMT

Hi,

Try adding your access point to the secured website.

You can do it from menu/tools in Internet explorer.

Regards,

Phani

Re: Help - Send to Excel error

Fri, 02 Nov 2012 10:03:54 GMT

Hi,

Am having the same problem even after adding the qlikview web address to the secure site. It had been working earlier but dont why now.

Regards,

Saukani