Vba get text file content

' Returns an array of lines from a text file
Function FileInArray() As Variant
    Dim fileSO As Object, textFile As Object, content
    On Error GoTo CExit
    Set fileSO = CreateObject("Scripting.FileSystemObject")
    Set textFile = fileSO.OpenTextFile("C:\temp\file.txt", 1)
    content = textFile.ReadAll
    FileInArray = Split(content, vbNewLine)
    textFile.Close
CExit:
End Function

Similar codes

0 vote158 views1 answer
Vba full date format
VBA
0 vote164 views1 answer
Vba vbcrlf chr
VBA
0 vote163 views1 answer
Excel delete ever other vba
VBA
5 votes103 views1 answer
Vlookup vba
VBA
0 vote148 views1 answer
Vba verticalalignment
VBA
0 vote235 views1 answer
Application.ExecutablePath VB.NET
VBA
1 vote170 views1 answer
How to remove zeros in excel
VBA
0 vote156 views1 answer
Internet explorer reference vba
VBA
2 votes163 views2 answers
Vba code to remove duplicates from a column
VBA
0 vote149 views1 answer
Open application from vbnet
VBA