How to rename an existing file in VB Script?

Question

I am very new to VB Script. I am trying to rename a file through VB Script could any one please help me in this ?

I just tried this but didn't work.

Dim OldFile As String
Dim NewFile As String

OldFile = "C:\apache-tomcat-8.0.44\apache-tomcat-8.0.44\webapps\" & "\" & timeStampDir & "\" & "output_11.docx"

NewFile = "C:\apache-tomcat-8.0.44\apache-tomcat-8.0.44\webapps\" & "\" & timeStampDir & "\" & "output.docx"
        Name OldFile As NewFile

GTAVLover · Accepted Answer · 2017-07-27T07:30:03.607

3

Use FileSystemObject and use Name property of a object referring the file you want to rename.

Dim OldFile, FSO, objFile
Set FSO = WScript.CreateObject("Scripting.FileSystemObject")

OldFile = "C:\apache-tomcat-8.0.44\apache-tomcat-8.0.44\webapps\" + CStr(timeStampDir) + "\output_11.docx"

Set objFile = FSO.GetFile(OldFile)
objFile.Name = "output.docx"

Keep in mind that you need to correctly escape all of the whitespaces in your oldFile variable, otherwise the file may not be found.

edited Jul 27 '17 at 07:30

answered Jul 27 '17 at 06:48

GTAVLover

1,407
3
22
41

2

Who is down-voting the answers? The answers are correct and working.... – Mithilesh Indurkar Jul 27 '17 at 06:56
1

@MithileshIndurkar I also wanted to find out who. answers are working. – GTAVLover Jul 27 '17 at 06:57

score -1 · Answer 2 · answered Jul 27 '17 at 06:45

-1

Set objFSO = CreateObject("Scripting.FileSystemObject")

objFSO.MoveFile OldFile, NewFile

Set objFSo = Nothing

answered Jul 27 '17 at 06:45

Mithilesh Indurkar

481
1
5
12

2

I don't want to move, its in same folder. – Rajesh Gurbani Jul 27 '17 at 06:46
This is just one of the easiest ways to rename the file. It does not create a duplicate file. Give it a try – Mithilesh Indurkar Jul 27 '17 at 06:47
Actually i am not from VB background, i tried to declare objFSO like : Dim objFSO AS FileSystemObject but getting error. Could you please help me. – Rajesh Gurbani Jul 27 '17 at 07:12
Set objFSO = CreateObject("Scripting.FileSystemObject") would work just fine... Why would you want to declare it like anything else. – Mithilesh Indurkar Jul 27 '17 at 07:13
Let me try again. – Rajesh Gurbani Jul 27 '17 at 07:15
It's Not Working. I am not getting any Error, but file name is still same – Rajesh Gurbani Jul 27 '17 at 07:21
@RajeshGurbani no it cannot happen. both methods should work fine. see my updated answer. – GTAVLover Jul 27 '17 at 07:23

How to rename an existing file in VB Script?

2 Answers2