Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

how can I send different objects to Excel in the same page

how can I send different objects  to Excel in the same page,

for example if I got a 3 tables  I need to send all to excel at the same time.

best regards.

1 Solution

Accepted Solutions
amit_saini
Master III
Master III

11 Replies
ecolomer
Master II
Master II

Can you try this

Script:

SUB SendToExcel

SET chart = ActiveDocument.GetSheetObject("CH01")

SET p = chart.GetProperties

chart.SendToExcel

END SUB

Please advise me how do i can limit the export to 'n' no. of rows.

ecolomer
Master II
Master II

Also you can use:

macro.png

Not applicable
Author

thanks a lot but, can I send this since a button?

ecolomer
Master II
Master II

yes indeed

must create a macro with the editor and put on a button and run

Can help you?

Not applicable
Author

you help me very much, thanks  .

it Works but ,send the tables to a diferent sheet.

can I do at the same sheet?

ecolomer
Master II
Master II

You can put the same name of sheet

ecolomer
Master II
Master II

I send you attached and example ...

Not applicable
Author

Enrique Thanks a lot , but the button appears like an text object

ecolomer
Master II
Master II

No,

The button are active and send two tables in two excel pages in the same file