email charts

  • Thread starter Thread starter MNaut
  • Start date Start date
M

MNaut

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
'=============================
 
Back
Top