Prevent Graph linking to old workbook after copying

[SimonVOwen]

Hello All,

I am running a macro that grabs data(array of data and a graph of this data) from a workbook and enters into another workbook.
However the graph keeps the old series links (this data is changed daily so changes the graphs in new wokbooks) is there an easy way to make it so the seris still relate to the data I copied it across with.

Regards,
Simon

 

[morningstar1001]

I prefer to do in this way:

• Keep 1 macro file with data and the graph as a form.
• Macro will copy data from other workbook to this workbook
• Macro also save as file to new workbook

So the graph in new workbook only link to that data on each day.

Otherwise, you can use VBA to get the filename of destination file (new data & graph) and change the properties of graph to link to correct file, but I think more complicate.