Export Shape as gif or bmp?

S

shockley

Is it possible to export a shape as a gif or bmp image to a Windows folder
using Excel or vba?
 
T

Tom Ogilvy

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
 
D

Don Guillett

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
 
S

shockley

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Chart Export in BMP format 2
Export autoshape as picture using VBA? (object doesn't support met 1
Export Chart as TIFF or JPG 8
Excel Macro Compatibility 7
Export Graphic OLE as jpg/gif or bmp 2
PowerPoint White Border from Powerpoint 2007 0
Clipboard images to Bitmap files through VBA in Excel 4
image & picture 2

Top