Renaming Files

[mudraker]

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

 

[BrianB]

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:

 

[mudraker]

BrianB

Thanks for your reply

It is exactly what I requir