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

[#1]

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.

[ecolomer]

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]

Also you can use:

[#4]

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

[ecolomer]

yes indeed

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

Can help you?

[#6]

you help me very much, thanks  .

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

can I do at the same sheet?

[ecolomer]

You can put the same name of sheet

[ecolomer]

I send you attached and example ...

[#9]

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

[ecolomer]

No,

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