export to Excel

[Anonymous]

Hi,

Is it possible to assign a function 'Export to Excel' to a text object or a button separate from a table?

Thank you in advacne,

Larisa

[Anonymous · Accepted solution]

Hi,

yes, I think the best way is using a macro from the button.

You can find macro for Excel export in the community, for example here:

Qlikview to excel export macro

I hope this can help you.

Regards.

[Anonymous]

Or simply use obj.ExportEx in the macro.

See attached file.

Regards.

[Anonymous]

Hi,

work this fine or not?

If this is ok close the thread, thank you.

Regards.

[Anonymous]

Hi,

I tried the file TestExport.qvw. In my desktop QlikView it doesn't work.

By the way, is the macro you suggest of the same nature as a standard Excel macro or is it a special QlikView macro?

Many of our users forbid to run macros in Excel settings. Does your suggestion take into account Excel settings of a particular user?

[Anonymous]

This is a macro of Qlikview, you can see this if you go to the button propreties and see actions.

I know that is better to dont use macro but I don know if you can do what you want to do from a button without a macro.