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

5 votes365 views1 answer
Excel vba how to unit test vba code
VBA
0 vote383 views2 answers
VB
VBA
0 vote391 views2 answers
S yyyy-MM-dd em vb net
VBA
0 vote366 views1 answer
Search for text in every worksheet excel visual basic
VBA
4 votes372 views1 answer
Vba create directory
VBA
0 vote349 views1 answer
Excel vba show developer tab
VBA
0 vote373 views1 answer
VB Error Code BC30201
VBA
0 vote344 views1 answer
Vba select file in folder
VBA
2 votes345 views1 answer
Date format for ms chart vb.net
VBA
0 vote375 views1 answer
Add text to combobox drop down vb
VBA