April 2006
Beginner
1114 pages
98h 16m
English
workbook.Charts
Returns a collection of chart sheets as Chart objects. Does not return charts that are embedded in worksheets. The following code saves each of the chart sheets as JPEG files:
For Each chrt In ThisWorkbook.Charts
chrt.Export ThisWorkbook.Path & "/" & _
chrt.Name & ".jpg", "jpeg"
NextRead now
Unlock full access