Dear Experts
With the following macro I am able to change Non English File Name without any problem. I do not know how to use this macro rename multiple files.
Please help me.
Also the above code doesn't save the file name as "*.jpg"ChangeFileName(sFile, tFile) On Local Error GoTo errors Dim fs, f, s Set fs = CreateObject("Scripting.FileSystemObject") fs.MoveFile sFile, tFile Set f = Nothing Exit Sub errors: MsgBox "File: " & sFile & vbCrLf & Err.Description Err.Clear End Sub Sub test() Const sDir = "C:\Users\TOSHIBA\Desktop\Fotos\" ChangeFileName sDir & Range("B3").Value, sDir & Range("C3").Value End Sub
Thanking you
Yours sincerely
Buvanamali




Reply With Quote