Hi

Here's code that open/process/close all workbooks in a folder:
http://www.contextures.com/xlfaqMac.html#LoopBooks

HTH. Best wishes Harald

"sharman" skrev i melding
...
I would like to have suggestions on what's the best best way for resolving
my
problem:

I have to turn in a report every week that consists of one summary sheet
and
25 other sheets. The Summary sheet reads data from the Totals field in the
25
sheets and displays it. The 25 sheets are sent to me by the different
departments. I want a program so that I can save all the 25 sheets /
workbooks in one folder when I receive them from the departments and then
run
the program that copies all the 25 sheets and the summary sheet template
to a
new workbook and then do the linking between the summary sheet and the 25
sheets. Is there a way to do it without having to open all the 25 sheets
and
then running the macro.

Thanks in advance.