Hi, I've spent a long time looking on the net and worked out how to used Visual Basic in excel to remame a bunch of files, you need to have the file names in the excel spreadsheet though, and it doesn't copy the files, just replaces the names...make sure you keep a back up! here's the 'code' i used:
'Visual Basic 6.5 renaming txt files
Sub RenameFiles1()
Dim SourceName As String
Dim DestName As String
Dim row As Long
ChDir "C:\Test_folder" 'Folder where all files are located
For row = 2 To 4 'My new filenames are in rows 2 to 4 of the spreadheet list
SourceName = ActiveSheet.Cells(row, 1).Value 'old file names in the spreadsheet list
DestName = ActiveSheet.Cells(row, 2).Value 'new file names in the spreadsheet list
Name SourceName & ".txt" As DestName & ".txt" 'txt can be changed for jpg for example
Next row
End Sub
!--removed tag-->
Enter your message below
Sign in or Join us (it's free).