Excel vba能不能处理文本文档

Excel vba能不能处理文本文档

给你一个例子自己学习一下，这是一个读写操作，基本过程就是
把已给路径的txt文件逐行读取到一个缓存里，但人为添加了回车换行，修改后，在会传到这个文件中

Public Sub TXTRWPractice()

Dim sBuf As String
Dim sTemp As String
Dim iFileNum As Integer
Dim sFileName As String
' Edit as needed
sFileName = ActiveWorkbook.Path & "\123.txt"
iFileNum = FreeFile
Open sFileName For Input As iFileNum
'读取文件
Do Until EOF(iFileNum)
Line Input #iFileNum, sBuf
sTemp = sTemp & sBuf & vbCrLf
Loop
Close iFileNum
'修改文件

sTemp = Replace(sTemp, "DIM A", "1.75")
sTemp = Replace(sTemp, "DIM B", "2.00")
sTemp = Replace(sTemp, "DIM C", "3.00")
sTemp = Replace(sTemp, "DIM D", "4.00")
'Save txt file as (if possible)

'写回传文件

iFileNum = FreeFile
Open sFileName For Output As iFileNum
Print #iFileNum, sTemp
Close iFileNum
'Close Userform
'Unload UserForm1

End Sub

可以，我就会！

肯定可以的

这个是可以的