Export pivot table in excel through macros

[#1]

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]

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

[stantrolav]

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