QUOTE(smcmanus @ 10 Oct, 2008 - 11:28 AM)
why will "Input #1, strInput" not fill up my array?
CODE
Sub test()
Dim strArray(5) As String
Dim strInput As String
strInput = "strArray(0), strArray(1), strArray(2), strArray(3), strArray(4), strArray(5)"
Open "c:\test.txt" For Input As #1
Do While Not EOF(1)
Input #1, strInput
Loop
Close #1
End Sub
Basically all I am tring to do is avoiding what you see below. I need the data to be in an array therefore I can't use Line Input #1. There must be a cleaner way using an array! Thanks
CODE
Sub test()
Dim strArray(5) As String
Dim strInput As String
Open "c:\test.txt" For Input As #1
Do While Not EOF(1)
Input #1, strArray(0), strArray(1), strArray(2), strArray(3), strArray(4), strArray(5)
Loop
Close #1
End Sub
** Edit **
| 