This content has been marked as final. Show 2 replies
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.