You can export the chart to your desired location through following code:
Sub exportChart()
Dim cht as chart
Set Cht = Worksheets("Charts").ChartObjects(1).Chart Cht.Export Filename:="C:\Temp\MyChart.gif", FilterName:="GIF"
End Sub
---------------------
I use this code to export chart and load them as image in Userform which looks pretty good for presentation.
Friday, May 15, 2009
Subscribe to:
Post Comments (Atom)


0 comments:
Post a Comment