Excel 2010 VB macro to open all files in folder and run a simple macro

Hi, I've recently upgraded to Office 2010. I was somewhat familiar with VB in earlier versions of Office. I usually use the recorder to set up my macros and adjust the simple things in VB. But, I'm really stuck. I've searched all over the forum and elsewhere on the web. I can't solve this one. Any help is appreciated!

I need a macro to open all *.xls files in a folder, run a simple macro on them, then save and close. The number of files varies (usually less than 100 or so) and the names of the files vary, but they're always in the same folder. The macro just sets the zoom at 100% and does a simple find and replace.

Thanks for any help!

Hi..

See comment sin code to see what you will need to change to adapt to your situation..

Please Login or Register  to view this content.

Thank you, apo! I changed the find and replace to this:

Please Login or Register  to view this content.

Your code worked great. I appreciate your help!