This worked great. I was getting an error message at first but added a
msgbox to tell me when the files were all formatted and it went away. Thansk!

"LoriH" wrote:

I have an excel macro that I created to format a spreadsheet a certain way.
I want to run this macro on all the files in a specified folder. I am new to
macros and VBA. What is the easiest way to do this?

Thanks in advance!