text files
EOF is end of file.
You could actually read it all in, all at once.
However, it depends on how you want to process it.
will each line in the text file be spread over multiple columns, or does all
the data in each line go in a single cell.
If the latter, you might want to use line input
--
Regards,
Tom Ogilvy
Stuart wrote in message
...
Think I have sort of worked it out myself, however could someone explain
what "EOF(1)" is all about, and do i really have to do this one char at a
time. Also, how much info could be got using this method (obviously i
would
not be putting it into a msgbog)
Sub getInfo()
Dim q, theData
Open "c:\Active\temp\testfile.txt" For Input As #1
Do While Not EOF(1)
q = Input(1, #1)
theData = theData & q
Loop
Close #1
MsgBox theData
End Sub
Stuart wrote in message
...
Is it possable to extract the data held within text files on the hard
drive
directly into a worksheet through VBA.
|