Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Macro help required to export data

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
ABZ2
BAY2
CDX5
DAW10

FirstLast
Count
IAK6
JKL8
MOA7
PS12

So Fianl result on Excel Sheet would be

FirstLast
Count
ABZ2
BAY2
CDX5
DAW10
IAK6
JKL8
MOA7
PS12

Can someone please help me or share a macro?

Thanks,

Dinesh

2 Replies
Not applicable

Macro help required to export data

Any solution for above query?

Many thanks,

MVP
MVP

Macro help required to export data

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

Community Browser