You can use the Name...As statement to do this...

Name "c:\Dir1\Dir2\OldFileName.ext" As "c:\Dir1\Dir2\NewFileName.ext"

Just change the example path, filename and extension to those for your
actual situation.

Note that you must provide the full path for both the old file name and the
new filename for this statement to work.

--
Rick (MVP - Excel)


"michelle439731" wrote in message
...
Afternoon,

I want to rename some files in a folder using vba.
Preferable what I would like to do is
a)find file x in folder a
b)rename file x to xy

Please can you help,

Cheers,

Michelle