Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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
Below is the link to the solution you need: Also I am attaching the file... Hope this helps.