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 vote365 views1 answer
Vba registry settings
VBA
0 vote360 views1 answer
Group controls programmatically vb
VBA
0 vote365 views1 answer
Remove last 8 characters from string vb
VBA
4 votes339 views1 answer
Excel vba Imitating the "IN" operator from python
VBA
25 votes506 views3 answers
String to date vb
VBA
0 vote349 views1 answer
Excel vba StartUpPosition
VBA
1 vote331 views1 answer
Excel vba Run a Macro every time sheet is changed
VBA
3 votes391 views1 answer
Extract word in a text in excel
VBA
1 vote314 views1 answer
Vba listindex select multiple items vba
VBA
0 vote353 views1 answer
How to get the value of optionbutton in vba
VBA