changing the name of a file

B

big G

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
 
F

Frank Kabel

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
 
Top