FreeFile Function
αααα‘ααβαααβα―αααΆαβαααβααΆαβαααααΆαα αααααΆααβααΎαβα―αααΆαβαα½αΒ α ααααΎβα’αα»ααααβαααβααΎααααΈβααΎαβα―αααΆαβαα½αβαααβααααΎβαααβα―αααΆα αααβαα·αβααΆααβααααΌαβααΆαβααααΎβαααβα―αααΆαβαααβααΎαβαα
αα
α»ααααααΒ α
α
ααα½αβααα
α’αα»ααααβαααβα’αΆα
βααααΌαβααΆαβααααΎβααααΆαα ααβααΈβαα»αβααα
ααααΈβαααααβααΆααα Open ααα»αααααβΒ α FreeFile αααα‘ααβαααβα―αααΆαβαααβααΆαβαααααΆαα ααα»ααααβαα·αβααααα»αβαα»αβααΆβααΒ α
5 ααΆαβα α
βαααααβαα·αβααααΉαααααΌα
67 α―αααΆαβα
αααΎαβααα
Sub ExampleWorkWithAFile
Dim iNumber As Integer
Dim sLine As String
Dim aFile As String
Dim sMsg As String
aFile = "C:\Users\ThisUser\data.txt"
iNumber = Freefile
Open aFile For Output As #iNumber
Print #iNumber, "This is a line of text"
Print #iNumber, "This is another line of text"
Close #iNumber
iNumber = Freefile
Open aFile For Input As iNumber
While Not eof(iNumber)
Line Input #iNumber, sLine
If sLine <>"" Then
sMsg = sMsg & sLine & chr(13)
End If
Wend
Close #iNumber
MsgBox sMsg
End Sub
Sub ExampleWorkWithAFile
Dim iNumber As Integer
Dim sLine As String
Dim aFile As String
Dim sMsg As String
aFile = "~/data.txt"
iNumber = Freefile
Open aFile For Output As #iNumber
Print #iNumber, "This is a line of text"
Print #iNumber, "This is another line of text"
Close #iNumber
iNumber = Freefile
Open aFile For Input As iNumber
While Not eof(iNumber)
Line Input #iNumber, sLine
If sLine <>"" Then
sMsg = sMsg & sLine & chr(13)
End If
Wend
Close #iNumber
MsgBox sMsg
End Sub