Current selections box on every sheet when exported to excel.

[Anonymous]

Hi,

I have five straight tables, I used a macro to create a single excel file with five straight tables in five sheets.

Now I want the current selections box on top of each table in every sheet.

Link I used to create the macro QlikTip #32: Exporting multiple QV objects to a single Excel document

Any help is appreciated,

SU.

[Siva_Sankar]

I never tested this. QlikTip #1: Transferring Current Selections to Excel-Export (translated)

[Anonymous]

Using that tip, the current selections are printing at bottom. I want them to print at top of the table. For one tab I have 100K records, user cant scroll all the way to bottom to see the selections.

[Siva_Sankar]

Ok. Find the attached application using macro to export to excel with current selection at the top.

-Siva

[paul_scotchford]

Try sorting the column with the selections on , in my example it was column A , result sample below...

[Anonymous]

I have 5 tabs, do I have to sort on all tabs?

[paul_scotchford]

Yes.

But one would ask why there is the need to export so much data from QlikView into Excel ?

[Anonymous]

I already have a macro to export 5 different objects to 5 tabs. How can I merge these two?

[Anonymous]

Users share that report with people outside the company during presentations.

[Siva_Sankar]

did you try the application attached by me in the above thread?