charts

[pistol]

Hello

Can stock charts that are already made up, be inserted,imported, copied into excel/


Thanks

 

[mercatog]

Hi pstol


You can export charts as image


For exemple, if you have a chartobject in your active worksheet, this code will export the chart into the folder where your workbook is stocked

[pre]

Sub ExportChartObject()

ActiveSheet.ChartObjects(1).Chart.Export ThisWorkbook.Path & "MyChart.gif"
End Sub

[/pre]

Regards