How to process multiple Excel Files

[Nils Titley]

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

 

[Steve]

Yes, put all your files in a separate directory.

Look up "Dir" in the Help file then loop through all the files to process
each file.

 

[Nils Titley]

Steve,

I appreciate you comment but I was hoping to get a little more help.

Thanks