email charts

I have an excel workbook file containing many department sales charts that
recieve data from a group of central data entry spreadsheets. Each
department chart resides on its own sheet. Is there a way to email
individual chart sheets (or snapshots of the chart sheet) to the respective
departments without sending the entire parent file to all recipients?
Thanks,
Mnaut

You could export the chart as a gif file, then email that file to the
department. The following code creates a gif file from the active chart:

'============================
Sub ExportChartGIF()
ActiveChart.Export Filename:="C:\Data\DeptChart.gif", _
FilterName:="GIF"
End Sub
'=============================

MNaut wrote:
> I have an excel workbook file containing many department sales charts that
> recieve data from a group of central data entry spreadsheets. Each
> department chart resides on its own sheet. Is there a way to email
> individual chart sheets (or snapshots of the chart sheet) to the respective
> departments without sending the entire parent file to all recipients?
> Thanks,
> Mnaut
>
>


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html