Breaking News: Grepper is joining You.com. Read the official announcement!

Copy and replace simple text in a txt file using vbs

Hackoo Crackoo answered on August 17, 2022 Popularity 1/10 Helpfulness 1/10

answer Copy and replace simple text in a txt file using vbs

Copy and replace simple text in a txt file using vbs

Comment

Option Explicit
Const ForReading = 1
Const ForWriting = 2
Dim objFSO,objFile,strText,strNewText,objRegEx
Set objFSO = CreateObject("Scripting.FileSystemObject")
Set objFile = objFSO.OpenTextFile("C:\Users\newtons\Desktop\Text.txt",ForReading)
strText = objFile.ReadAll
objFile.Close
Set objRegEx = CreateObject("VBScript.RegExp")
objRegEx.Global = True   
objRegEx.IgnoreCase = True
objRegEx.Pattern = "jim"
strNewText = objRegEx.Replace(strText,"James")
Set objFile = objFSO.OpenTextFile("C:\Users\newtons\Desktop\Text.txt",ForWriting)
objFile.WriteLine strNewText
objFile.Close
set objFSO = Nothing
set objFile = Nothing

Popularity 1/10 Helpfulness 1/10 Language vb

Source: stackoverflow.com

Tags: copy file text txt using vba

Link to this answer
Share Copy Link