Thread: Can I get a chart to an image file?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Don Guillett[_4_] Don Guillett[_4_] is offline
external usenet poster
  
Posts: 2,337
Default Can I get a chart to an image file?
fixed

--
Don Guillett
SalesAid Software

"Tom Ogilvy" wrote in message
...
Might want to fix your clock.

January 6th ??

--
Regards,
Tom Ogilvy

"Don Guillett" wrote in message
...
try one of these
Sub ExportChartGIF()
ActiveChart.Export Filename:="C:\a\MyChart.gif", _
FilterName:="GIF"
End Sub

Sub ExportChartJPG()
ActiveChart.Export Filename:="C:\a\MyChart.jpg", _
FilterName:="jpeg"
End Sub


--
Don Guillett
SalesAid Software

"Lynda" wrote in message
...
My excel speadsheet at work has 2 charts on it and I need
to send them out to my colleagues does anyone know any vb
to have a button which will create 2 files on my desktop
which are images containing the two charts?








Reply With QuoteReply With Quote