Morning all, just joined as can not find the answer to a question I have searched for hours to try and solve. I have done this in the past but can not find the original file, or page showing how to do it.
All I want is a simple way to export named charts from within vba, the best guess I could come up with was this:
Sub Export()
Charts(ChartName).Activate
With ActiveChart
ActiveChart.Export "C:\MAPBOOK_OUTPUTS\ChartName.png"
End Sub
Thanks in advance for any help!
All I want is a simple way to export named charts from within vba, the best guess I could come up with was this:
Sub Export()
Charts(ChartName).Activate
With ActiveChart
ActiveChart.Export "C:\MAPBOOK_OUTPUTS\ChartName.png"
End Sub
Thanks in advance for any help!