The charts remain linked to the original data sheets. If you need to
keep the data with the charts, you are probably better off just copying
the whole workbook, unless you want to write a lot of code to separate
out the data for your charts, change the source data range to this
extracted data, etc.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


hong wrote:

Thanks a lot! Jon. In my case, they are chart sheets. I have a Excel
file named " Results1" and there're about three chart-sheets in it. Say
chart1, chart2 and chart3. What I want to do is copy and save those
charts into a new Excel file and name it as" Charts output1" in a
particular folder( or a msgbox asking the user to choose a location).
The reason why I name these two files with a number 1 is because I need
to do a loop to repeat the " copy and save" process to deal with around
100 files. And I wonder when I copy the chartsheets if I also need to
copy the source data of those charts? Thanks again!