Thread: text files
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default 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.