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

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" wrote in message
...
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,

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

Thanks

"Steve" wrote:

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" wrote in message
...
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