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 vote252 views1 answer
Code for reading letters only in vb 6
VBA
0 vote237 views2 answers
How to update date and time automatically once id is entered in excel vba
VBA
6 votes245 views1 answer
Excel vba check if a string only contains letters
VBA
0 vote249 views1 answer
Vba string
VBA
0 vote236 views1 answer
Vba open report
VBA
3 votes254 views1 answer
Vba continue for each loop
VBA
0 vote227 views1 answer
Vbnet hex to binary
VBA
0 vote229 views1 answer
Hello world vb.net
VBA
0 vote255 views1 answer
Remove first character from string vb
VBA
3 votes266 views2 answers
Vba active workbook path
VBA