running an excel program

[Al]

A colleague wrote a program in excel that runs my data and does a good job.
(I think it's a macro).

Problem is -
I'd like to run this program over night - incrementing to the next file that
needs to be run.
To run the file, I open an excel file and hit a button he labeled "Process
data".

example:
file1 runs, when it's finished, I'd like the program to go to the next file
and run it.
And so on...
Thanks for any help!
Al.

 

[Joel]

You need to post the macro.

1) From worksheet press ALT-F11
2) On the right hand side of window you will see the project window. Macro
can be located in three places. You need to double click on the Project
window in the correct location to find all the macros

Place to find macros
1) Thisworkbook
2) On any of the sheets in your workbook. These will have the same name as
the sheet name
3) In a module. Press the plus sign next to module and the double click on
each of the modules.

There may also be macros on any forms that may be in the project.