Rename file excle

[nungaorae]

Want to rename file .xls
ex: test.xls rename to ==> data_ test.xls

thank you

:help

[Dave]

You're missing some information....Do you want to do this with code? (Else right click on the file and rename) Is the code in the test.xls wb? (See save as) Do you want to rename the file from another wb? (See copyfile and then Kill the original fileO) Abit more info will probably get the help that you need. Good luck. Dave

[Bob Phillips]

Name "C:\test.xls" As "C:\data_test.xls"

[nungaorae]

I want code for rename in excel.
if in folder have many file.xls,i want to rename all file.
ex : the folder have 1.xls,2.xls,3.xls
if process complete then file name change to data_1.xls,data_2.xls,data_3.xls

thak you again.

[mdmackillop]

Sub Renames()
Dim MyName As String
Dim MyPath As String
MyPath = "C:\AAA\"
MyName = Dir(MyPath & "*.xls")
Do Until MyName = ""
Name MyPath & MyName As MyPath & "Data_" & MyName
MyName = Dir
Loop
End Sub

[L@ja]

I'ill a little devil :-)
if u have a totalcommander
ctrl+a and ctrl+m
:-)