[RESOLVED] Saving charts - Excel VBA

Hey all,

Is there anyway to save a chart, without saving the sheet the chart is on and saving the accompanying source data (sometimes several different sheets)?

Preferably, just saving the chart as .jpg or something similar? Seems like it may be a long shot, but I figured there may be a way. Besides just having the user create a screenshot...

Thanks

The code in this reference will copy a chart to the clipboard then save it as a BMP file.

http://www.bmsltd.ie/DLCount/DLCount...stePicture.zip

oh wow that would be great!... but I think that is a dead link w/ the "..."?

thanks much though man

Quote:

---

Originally Posted by pgag45

oh wow that would be great!... but I think that is a dead link w/ the "..."?

---

That's odd. Anyway, look in the last post of the following thread - the link is there and works.

http://www.vbforums.com/showthread.php?t=459369

fantastic thanks again.