Export multiple objects to one excel spreadsheet

[#1]

I need some help to export multiple objects from my application (one sheet) to one excel spreadsheet.

I know that the efficient way to do it is with a macro, but I  don't know too much about macros yet.

I would appreciate a lot any help/solution provided

Thanks!

[el_aprendiz111]

Hi,

1 example:

sub send_Excell

SET CHART = ActiveDocument.GetSheetObject("CH27")

SET X = Chart.GetProperties

CHART.SendToExcel

SET CHART=NOTHING

SET X = NOTHING

end sub

[trdandamudi]

Below is the link to the solution you need: Also I am attaching the file... Hope this helps.

Macro to export multiple tables in to single excel