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!