topic Macro help required to export data in QlikView

Macro help required to export data

Tue, 02 Aug 2011 11:15:27 GMT

Hello,

How can i run a macro to export all sheetobjects to one sheet in excel workbook (not different sheet)? NOTE: All objects have got same header.

example objects:

First	Last	Count
AB	Z	2
BA	Y	2
CD	X	5
DA	W	10

First	Last	Count
IA	K	6
JK	L	8
MO	A	7
P	S	12

So Fianl result on Excel Sheet would be

First	Last	Count
AB	Z	2
BA	Y	2
CD	X	5
DA	W	10
IA	K	6
JK	L	8
MO	A	7
P	S	12

Can someone please help me or share a macro?

Thanks,

Dinesh

Macro help required to export data

Wed, 03 Aug 2011 08:20:37 GMT

Any solution for above query?

Many thanks,

Macro help required to export data

Miguel_Angel_Baeyens — Wed, 03 Aug 2011 08:55:34 GMT

Hello Dinesh,

Take a look at this post (among many others) on how to export to excel. Now you will need to add as many paste lines as different tables you have. You better use CopyValuesToClipboard from the second line on, you only need the headers once. Besides, you will need to do some tweaking to get the proper range where to paste the contents. If your tables have the same number of rows, this will be quite easy.

Hope that helps.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica