changing the name of a file

  • Thread starter Thread starter big G
  • Start date Start date
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
 
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
 
Back
Top