send entire report to excel

[#1]

Hi,

Inside a .qvw document, I have created a document report. (Reports --> Edit Reports)

Is there any option to send this report to excel?

Regards,

Anju

[Anonymous]

PFA the latest version of qvw.

I have done following changes below:

1. Document properties > Security > Macro override security checkbox ticked.

http://community.qlik.com/thread/67941

2. User Preferences>Export tab allowed export for Charts and Tables.

http://community.qlik.com/message/354207

Now the only error I am getting is "Copy to clipboard Fail"

The Logical solution seems is to add a delay for every chart and also to clear the clipboard after every paste.

I am exploring options to do the same using VbScript.

Let me know if you can help solve this problem.

Thanks a ton for all the help till now.

Regards,

Saurabh Pandit

[schivet]

Hello Saurabh,

Did you find a solution to clear the clipboard?

Thanks

Stéphane

[Anonymous]

Hi Stephane,

I don't remember now as its a old post. I will try and work on the app over weekend and let you know if I can find a solution.

Cheers,

Saurabh

[schivet]

Hi Saurabh,

I have added this comand in the module to empty the clipboard:

It did work for a few days but not we still have the problem again!

"Copy to clipboard Fail"

Hope you find something.

Thanks

[Anonymous]

If it worked after the above code then some external changes might have been done causing the re emergence of the error.

I couldn't figure out a solution though.

[schivet]

ok, thank you!