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

"shockley" wrote in message
...
Is it possible to export a shape as a gif or bmp image to a Windows folder
using Excel or vba?

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
"shockley" wrote in message
...
Is it possible to export a shape as a gif or bmp image to a Windows folder
using Excel or vba?

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



"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
"shockley" wrote in message
...
Is it possible to export a shape as a gif or bmp image to a Windows
folder
using Excel or vba?

Hi shockley,

This may save you some time.
(http://www.andypope.info/vba/gex.htm)

shockley wrote:

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



"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
"shockley" wrote in message
...

Is it possible to export a shape as a gif or bmp image to a Windows

folder

using Excel or vba?







--

Cheers
Andy

http://www.andypope.info

Thanks, I'll give it a try.


"Andy Pope" wrote in message
...
Hi shockley,

This may save you some time.
(http://www.andypope.info/vba/gex.htm)

shockley wrote:

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



"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
"shockley" wrote in message
...

Is it possible to export a shape as a gif or bmp image to a Windows

folder

using Excel or vba?







--

Cheers
Andy

http://www.andypope.info