yes, you are right that all files are within 1 folders altho we do have a
number of folders that are broken down by product type so we assume that this
process would have to be done to each folder.

Will take a look at the link you provided.

THANKS!

"JMB" wrote:

This may be useful to take a peek at:

http://www.mvps.org/dmcritchie/excel/getstarted.htm

BTW - my suggestion also assumed all of the files were in one folder and all
of the files in that folder are supposed to be renamed.


"Jane" wrote:

wow! thank you for your responses!

We are a bit shaky on our macro skills but will do our best to implement
your solutions.

By chance is there a non macro solution? Thought I would ask :)

thank you again! Jane

"Jane" wrote:

We need to change the file names of 65 files by adding the same 1 word to the
beginning of each file name.

Is it possible to do a global save as so we do not have to re-name each file?

thank you in advance! jane