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

Photo rotation within a shape - Microsoft 2013 0
Visio: copy text of a master shape to User-define Cells (Variable) 0
Solved Disk Full error message when exporting PDF 0
Adding gifs to Publisher 0
Merging from an Excel file with graphics 1
Visio to Excel 0
bmp from scratch 2
Save workbook without shapes 0

Top