Export to Excel by Button

[#1]

jagan‌ vinay_bangari‌ ecolomer‌

Hi Experts,

I'm not familiar with macros at all…! Unfortunately, not even the basics..

I need a button that will export a table to excel. Please find the attached qvw file below.

Thank you in advance.

[m_woolf]

Please search the forum. You will find many examples.

Be advised that this macro will not work with Ajax. Only with IE and the plug-in.

[hjweber]

Hi Raji,

see the example.

[#4]

Please check the attachment

The file name is written in the macro.
It is generated in the same folder where the qvw.
If you need you can add a new action to open automatically with the application you want

[Anonymous]

Urgent need help on sending Qlikview reports in any exported format to users Email.

check this discussion which i posted earlier

[#6]

Hi Gennaro,

thanks for ur help. its working.. One more question..

Can i add the Current selection Box to the same Excel sheet which you have created. So that it shows the filters on top.

Thanks in advance.

[#7 · Accepted solution]

Yes check the attachment

If it is correct, do not forget to mark the discussion as answer

Regars

Gennaro

[#8]

Hi Gennaro,

I have tried to use the Macro for other objects also by changing the OBJECT ID in the Macro. But some how its not working. When i have tried to use i don't know why the values are changing automatically. Please help and find the attached QVW file to the question.

[#9]

Hi Raji,

look the attached file with the changes to export the various tables that you've created.
I modified the macro so that the parameter object to export is specified by a variable.

[#10]

Thank You its working...