Hi
you can use the VBAName statement:
sub foo()
strDirectory = "C:\temp\"
strName1 = "old_name"
strName2 = "new_name"
Name strDirectory & strName1 As strDirectory & strName2
end sub

Frank

big G wrote:
Is there anyway to change the name of a file using VBA, also the
files wont be excel workbooks.

I have a macro that lists all the files in a selected directory in a
workbook, and want to modify it so you can change the name of any of
the files remotely.


Cheers,


G