To understand what the code does, it would be best to run the code which works fine. The code seems to only work on one file at a time but ends up renaming all of the files in a folder which is what I want.

I would like to see if someone can add some more code to do the following.

(1) Generate a prompt to enter characters to put both right before .xls and in cell A1. I would like the suffix to be the same for all of the files.

(2) Copy the font formatting from cell B1 to cell A1

(3) Put the date and time in cell W1 that is found in cell B2. The text in cell B2 always has the following format "Requested 12345678901234567 (US) on 06/26/2014, 13:58" where "12345678901234567" represents a unique string about 10-17 characters long.

Thanks for working on this code which I guess I should soon learn to do myself. I guess I hadn't explained what I wanted very well.