Convert excel to gif

  • Thread starter Thread starter mani
  • Start date Start date
Get a screen capture program. There are plenty of free ones, do a Google
search.

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Hi,

The chart has an export method you can use from VBA.

ActiveChart.Export "C:\temp\mychart.gif", "gif"

Cheers
Andy
 
Mani

Sub SaveAsGIF()
' Saves the active chart as a GIF file
' Prompts for a file name and directory
Dim FileName As Variant
If ActiveChart Is Nothing Then
MsgBox "Select a chart to export."
Else
FileName = Application.GetSaveAsFilename( _
InitialFileName:=ActiveChart.Name & ".gif", _
FileFilter:="GIF Files (*.gif), *.gif", _
Title:="Save chart as GIF file")
If FileName <> False Then ActiveChart.Export FileName, "GIF"
End If
End Sub

Gord Dibben Excel MVP
 
You must log in or register to reply here.

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

.png to .gif with convert tool. 13
best way to export chart 4
gif image 2
how do I create a gif/jpg file of a table in Excel? 2
What program can i use to convert extentions jpg to csv. ensofort. 6
Howdy! Need a little help with code... 3
Change date format 0
Peeqo the GIF bot 4

Back
Top