I have created a Macro that processes an excel file. Now, I need to be able
to use the same macro to process 9 to 60 files and create a report that is
written to one excel file.

I am thinking that the files to be processed would be in a separate directory.

I would appreciate some help with this.

Thanks to those people that helped me with the Macro. I have expanded the
complexity of the macro.

Thanks