第1个回答 推荐于2016-01-05
用FSO可以每次都写一行:
Sub Create_File()
Dim fso, txtfile
Set fso = CreateObject("Scripting.FileSystemObject")
Set txtfile = fso.CreateTextFile("c:\testfile.txt", True)
' 写入一行带有换行符的文本。
txtfile.WriteLine("Testing 1, 2, 3.")
txtfile.Close
End Sub
第2个回答 2012-02-14
全部读取后再全部写入文件:
Sub aaa()
On Error Resume Next
Filename = "c:\123.txt"
Dim arr() As Byte
ReDim arr(FileLen(Filename))
Open Filename For Binary As #1
Get #1, , arr
Close #1
Open Filename For Output As #1
Print #1, "新首行字符串:abcd" & vbCrLf & StrConv(arr, vbUnicode);'主要最后面的;,不能少的,否则将加入一空行
Close #1
End Sub