Marco to take Screenshoot and save it as PNG

[manishbafana]

Hi,

Need help!!

I have a excel workbook with 7-8 sheets, I have pivot charts in each of the sheet. I need to take snapshot at 90% and save the image as .PNG. Can anybody help me with the code to do this.

Thanks,
Manish

 

[sriram170]

i dont think so excel has ability to take snap shots of its own objects, but i think so can save the chart as picture.. let me try if its suceess i may post the solution