I need some VBA code that will allow me to change the names of a larg
number of files spread through several sub directories.

These files are a combination of Excel, Word Docs, Text files.

Any assistance would be greatly appreaciated

thanks in advanc

--
Message posted from http://www.ExcelForum.com

Use "Name" which includes the full path. You can do this with any file.
Keep the same suffix eg. .xls .doc etc. The syntax is :-


Code:
--------------------
Name "C:\temp\OldName.xls" As "C:\temp\NewName.xls"
--------------------



---
Message posted from http://www.ExcelForum.com/

BrianB

Thanks for your reply

It is exactly what I requir

--
Message posted from http://www.ExcelForum.com