• Home
 · 
• Files/File Controls/Input/Output
 · 
• This code reads a comma separated text file,split the lines based on comma and then display then in

This code reads a comma separated text file,split the lines based on comma and then display then in

This code reads a comma separated text file,split the lines based on comma and then display then into a list box.

Rate This code reads a comma separated text file,split the lines based on comma and then display then in

• 1
• 2
• 3
• 4
• 5

(1(1 Vote))

Dim textfile As String
Dim strArray() As String

Open "C:\test.txt" For Input As #1
  Do While Not EOF(1)
   Line Input #1, textfile
   strArray = Split(textfile, ",")
   For i = 0 To UBound(strArray)
   If Not Trim(strArray(i)) = "" Then
   List1.AddItem strArray(i)
   End If
   Next
  Loop
Close #1

End Sub