View Full Version : Rename file excle
nungaorae
03-31-2008, 05:51 AM
Want to rename file .xls
ex: test.xls rename to ==> data_ test.xls
thank you
:help
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
03-31-2008, 06:05 AM
Name "C:\test.xls" As "C:\data_test.xls"
nungaorae
03-31-2008, 06:32 AM
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
03-31-2008, 02:53 PM
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
I'ill a little devil :-)
if u have a totalcommander
ctrl+a and ctrl+m
:-)
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.