Hi Karen,

There is a Name statement

name Old_name as New_name

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Karen Howie" wrote in message
...
Hi folks,

I'd like to write a macro which loops around a table in excel changing a
directory name (listed in one column) to another name (listed in a second
column). What is the command to change a directory name?

Thank-you!

Karen