Macro to open all files, make changes, save and close

Hi all

Can anyone help me?

I have a directory (C:\temp) of 300 excel files that need a change in each file.

What I want is a macro that will open each file in the directory, make a change (via another macro), and then save and close, then open the next file and so on and so on till all files are complete.

Obviously I could do this by opening each file manually, running the change macro and saving, but obviously so time consuming.

Can anybody help me with some code???

Many thanks in advance,
CD

Have a look here: http://www.ozgrid.com/VBA/loop-through.htm