topic Export multiple objects to one excel spreadsheet in QlikView

Export multiple objects to one excel spreadsheet

Wed, 25 Nov 2020 16:16:04 GMT

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 — Fri, 18 Nov 2016 22:39:04 GMT

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 — Sat, 19 Nov 2016 03:45:56 GMT

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