[RESOLVED] Saving charts - Excel VBA

[pgag45]

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

[VBAhack]

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

[pgag45]

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

thanks much though man

[VBAhack]

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

[pgag45]

fantastic thanks again.