topic Export pivot table in excel through macros in QlikView

Export pivot table in excel through macros

Thu, 01 Aug 2013 15:44:07 GMT

Hi,

I want to export pivot table in excel format through macros.

I have write down macros to export pivot table but following challenges are coming:

1. Images in pivot table are not coming in excel so I want to take export image of an object in the excel report.

2. I want to merge images of different pivot tables in one excel report.

Anyone know How can I do this using VB script.

Any suggestions are welcome.

Thanks

Gysbert_Wassenaar — Thu, 01 Aug 2013 17:11:53 GMT

stantrolav — Wed, 04 Dec 2013 10:43:14 GMT

set Obj = ActiveDocument.GetSheetObject("CH46")

obj.ExportEx "C:\1\ADDRESS.csv", 1, false, "^_^", 28591

CH46 - number of you table

C:\1\ADDRESS.csv - File that'll be created

^_^ - Cat