Export Shape as gif or bmp?

  • Thread starter Thread starter shockley
  • Start date Start date
S

shockley

Is it possible to export a shape as a gif or bmp image to a Windows folder
using Excel or vba?
 
Export is a property of a chart, so you would have to put the shape on a
chart and export the chart. You can create a blank chart, so that approach
isn't as far fetched as it might sound.

Regards,
Tom Ogilvy
 
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
 
Thanks to both of you. It looks like it will work--I'm going to see how far
I can go with it.

Regards,
Shockley
 
Back
Top