VBA chart Question

[dualhcsniatpac]

I have 1 file that will be all charts.

Another file is all data.

Do I have to OPEN the data file to populate the charts with the data that is in there??

Or will it just update??

ActiveSheet.Shapes.AddChart.Select
    ActiveChart.ChartType = xlXYScatterLines
    
    ActiveChart.SeriesCollection.NewSeries
    ActiveChart.SeriesCollection(1).Name = "='[High Volume Scrap 2009.xls]Volume and Buy Back 2009'!$B$1"
    ActiveChart.SeriesCollection(1).XValues = "='[High Volume Scrap 2009.xls]Volume and Buy Back 2009'!$B$2:$B$4"
    ActiveChart.SeriesCollection(1).XValues = "='[High Volume Scrap 2009.xls]Volume and Buy Back 2009'!$A$2:$A$4"
    ActiveChart.SeriesCollection(1).Values = "='[High Volume Scrap 2009.xls]Volume and Buy Back 2009'!$B$2:$B$4"
    
    ActiveChart.SeriesCollection.NewSeries
    ActiveChart.SeriesCollection(2).Name = "='[High Volume Scrap 2009.xls]Volume and Buy Back 2009'!$C$1"
    ActiveChart.SeriesCollection(2).XValues = "='[High Volume Scrap 2009.xls]Volume and Buy Back 2009'!$A$2:$A$4"
    ActiveChart.SeriesCollection(2).Values = "='[High Volume Scrap 2009.xls]Volume and Buy Back 2009'!$C$2:$C$4"
    
    ActiveChart.SeriesCollection.NewSeries
    ActiveChart.SeriesCollection(3).Name = "='[High Volume Scrap 2009.xls]Volume and Buy Back 2009'!$D$1"
    ActiveChart.SeriesCollection(3).XValues = "='[High Volume Scrap 2009.xls]Volume and Buy Back 2009'!$A$2:$A$4"
    ActiveChart.SeriesCollection(3).Values = "='[High Volume Scrap 2009.xls]Volume and Buy Back 2009'!$D$2:$D$4"

Can I do the above? I know I can but will it work without opening the High Volume Scrap 2009 file???

Thanks!