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!