Adding functionality to macro for Excel export

Wed, 03 Dec 2014 10:08:46 GMT

Hello community,

I'm trying to export charts and tables to Excel with the macro provided in this article:

http://www.qlikblog.at/971/qliktip-32-exporting-multiple-objects-single-excel-document/

'// ****************************************************************
'// Export of multiple objects in different formats (data & image)
'// In one case (sheet "Sales Overview") two objects are placed on
'// one sheet.
'// ****************************************************************
Dim aryExport(4,3)

aryExport(0,0) = "objSalesPerRegion"
aryExport(0,1) = "Sales Overview"
aryExport(0,2) = "A1"
aryExport(0,3) = "image"

The macro works nicely, but I would like to also grab or set the caption of each object for the export so that I can place it above each chart in the Excel document.

I wouldn't mind setting it manually but of course it would be nicer to get the text directly from the caption.

Can I also use a text object and write it in a cell in Excel?

Any ideas how I need to modify above macro to include this functionality?

Thank you,

Thorsten

topic Adding functionality to macro for Excel export in QlikView

Adding functionality to macro for Excel export