Export chart in an excel as a picture through VBA

[ankita.sethi]

hi,

I am preparing a report where I want to give the user the option to export charts as a picture and save it to whichever location they want.

Can anyone tell me if this is possible?

 

[VoG]

Yes it is possible, see http://peltiertech.com/WordPress/export-chart-as-image-file/

 

[ankita.sethi]

Thanks a lot!
It works great!!