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

1 vote223 views1 answer
Vba date to unix timestamp
VBA
0 vote229 views1 answer
Dlete rows with blanks and space " " vba
VBA
3 votes281 views1 answer
Excel vba make long from two shorts
VBA
0 vote213 views1 answer
Faire appel à la mise en forme conditionnelle vba excel
VBA
0 vote240 views1 answer
.net dark title bar
VBA
0 vote239 views1 answer
Vbs run with cscript
VBA
8 votes500 views1 answer
Vba convert 2 bytes to an integer
VBA
0 vote216 views1 answer
Vb.net round to 2 decimal places
VBA
8 votes249 views1 answer
Excel vba make integer
VBA
0 vote242 views1 answer
Vba search string position
VBA