Exporting a chart

[smund]

In my test.xls I have a sheet(Chart1) and I need to do a macro to export the chart and save as *.gif.
Can you help me?

 

[indiantrix]

I have little experience with macros. However, if I had a chart on its own sheet and wanted to put it into, say, a Word Document, I would:
1. Select the chart so it had the squares in each corner
2. Hold down my Shift Key
3. Click Edit/Copy Picture
4. Click OK.
5. Go to Word Doc and Edit/Paste Special, Picture.
Hope this can help you.
Anyone else?
Larry

 

[NdNoviceHlp]

Dim "Fname" as string. HTH. Dave

Fname = ThisWorkbook.Path & "\" & "Yourfilename.gif"
ActiveChart.Export Filename:=Fname, FilterName:="GIF"