Print Charts
Little doubt that it could be done. You could write code that lists all
workbook's complete paths/names and have it open them one at a time, find a
sheet with a chart on it (be nice if chart sheets all had same name), and
print the sheet within a loop.
Another way would be to have only those files in a specific folder and have
your macro simply access each .xls file in the folder in turn (except for
itself) and then do same process regarding finding the chart sheet(s) and
printing them.
"Beep Beep" wrote:
I have twelve workbooks that each contain 2 worksheets. One worksheet
contains data and the other contains a chart.
Is there a way that I can call up the individual workbooks and then print
out just the chart tab, save and call up the next workbook. All this done
with one Macro.
Thanks
Frank
|