Save charts of a workbook into another new workbook

[Ming]

Hello! All. I want to save some charts in an Excel file(workbook1) into
a new Excel file(workbook2) and save the new Excel file as a new name
and in a fixed location of some folder. Could anybody give me some
suggestions? BTW, I wish to develop some VBA code to do it
automatically. Since I want to do it within a loop, I prefer there's no
manual intervention. Thanks in advance!

 

[hong]

I'd like to know how to slove this problem. If anybody could help him
out. Thanks!

 

[hong]

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, cause the origianl file will be
updated by time? Could anybody give me some sample suggestions? Thanks!