Using VBA 2000, I need to read a comma seperated text file "C:\Textfile.txt".
It will always have only 1 line.
It could have 2 to 6 values at anytime.
I've attached the code that I've been trying. It is reading the file and storing the line of csv's into sTemp, but I haven't got "Split" to work. Not sure if I just don't know how to use it or if I should try something else.
I need to store each value in a variable. How can I accomplish this?
Dim sLayout, sTemp As String
Open "C:\add_slide.txt" For Input As #2
Line Input #2, Value$
sTemp = Value$
sLayout = Split(sTemp, ",")