Open "C:\a.book" For Input As #1 ' 打开文件。 Do While Not EOF(1) ' 循环至文件尾。 Line Input #1, TextLine ' 读入一行数据并将其赋予某变量。 Debug.Print TextLine ' 在立即窗口中显示数据。 Loop Close #1 ' 关闭文件。
这是个文本文件的读写问题 Option ExplicitPrivate Sub Command1_Click() OpenFile End SubSub OpenFile() '打开文件 Dim fs As New FileSystemObject Dim ObjText As TextStream Dim sFileName As String Dim objTarget As TextStream Dim sTemp As String With cdlFile .CancelError = True .FileName = "" .Filter = "TXT(*.txt)|*.txt" .DialogTitle = "打开文件" .ShowOpen sFileName = .FileName End With
Set ObjText = fs.OpenTextFile(sFileName, ForReading, True, TristateFalse) Set objTarget = fs.OpenTextFile("C:\abc.txt", ForWriting, True, TristateFalse)
objTarget.Write ObjText.ReadAll '读写文件
objTarget.Close ObjText.Close
MsgBox "文件已写入C:\abc.txt"
End Sub
redim array() as string,i as integer,num as integer num=freenumber Open "c:\a.book" For OutPut num while not eof(num) line input num,arrary(i) i=i+1 redim arrary(i) wend close num
Open "C:\a.book" For Input As #1 ' 打开文件。
Do While Not EOF(1) ' 循环至文件尾。
Line Input #1, TextLine ' 读入一行数据并将其赋予某变量。
Debug.Print TextLine ' 在立即窗口中显示数据。
Loop
Close #1 ' 关闭文件。
Option ExplicitPrivate Sub Command1_Click()
OpenFile
End SubSub OpenFile()
'打开文件
Dim fs As New FileSystemObject
Dim ObjText As TextStream
Dim sFileName As String
Dim objTarget As TextStream
Dim sTemp As String
With cdlFile
.CancelError = True
.FileName = ""
.Filter = "TXT(*.txt)|*.txt"
.DialogTitle = "打开文件"
.ShowOpen
sFileName = .FileName
End With
Set ObjText = fs.OpenTextFile(sFileName, ForReading, True, TristateFalse)
Set objTarget = fs.OpenTextFile("C:\abc.txt", ForWriting, True, TristateFalse)
objTarget.Write ObjText.ReadAll '读写文件
objTarget.Close
ObjText.Close
MsgBox "文件已写入C:\abc.txt"
End Sub
num=freenumber
Open "c:\a.book" For OutPut num
while not eof(num)
line input num,arrary(i)
i=i+1
redim arrary(i)
wend
close num