Afternoon,
I want to rename some files in a folder using vba.
Preferable what I would like to do is
a)find file x in folder a
b)rename file x to xy
Please can you help,
Cheers,
Michelle
Afternoon,
I want to rename some files in a folder using vba.
Preferable what I would like to do is
a)find file x in folder a
b)rename file x to xy
Please can you help,
Cheers,
Michelle
you can make use of the NAME command.
From help file.
Dim OldName, NewName OldName = "OLDFILE": NewName = "NEWFILE" ' Define file names. Name OldName As NewName ' Rename file.
Thanks Andy! I've got it working now.
Cheers,
Michelle
Be very care wil this one -- TEST FISRT
Bit hardcore but your see what i meanName "C:\myFileX.xls" As "C:\myFileXY.xls"
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks