VBA-FileToFileUpdate
阅读原文时间:2023年07月15日阅读:2

Public Sub FileToFileUpdate(ByVal fileName As String, ByVal strFrm As String, ByVal strTo As String)

Dim newFileName As String

newFileName = fileName & "_bak"

Name fileName As newFileName

Dim vFso As New Scripting.FileSystemObject
Dim vTextStreamR As TextStream
Dim vTextStreamW As TextStream

Set vTextStreamR = vFso.GetFile(newFileName).OpenAsTextStream(ForReading, TristateUseDefault)

Call vFso.CreateTextFile(fileName, True)

Set vTextStreamW = vFso.GetFile(fileName).OpenAsTextStream(ForWriting, TristateUseDefault)

Do Until vTextStreamR.AtEndOfStream

vTextStreamW.WriteLine Replace(vTextStreamR.ReadLine, strFrm, strTo)

Loop

Set vTextStreamR = Nothing
Set vTextStreamW = Nothing

Call vFso.DeleteFile(newFileName)
Set vFso = Nothing

End Sub

手机扫一扫

移动阅读更方便

阿里云服务器
腾讯云服务器
七牛云服务器

你可能感兴趣的文章