text files

  • Thread starter Thread starter Stuart
  • Start date Start date
S

Stuart

Is it possable to extract the data held within text files on the hard drive
directly into a worksheet through VBA.
 
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
 
In Excel 2000 and later, you can do Data=>Get External Data => Import Text
file.

Turn on the macro recorder while you do it manually to get the code you
need.

In earlier versions you can use low level file io or you can open it as a
new workbook, copy it across, then close the original file without saving.
 
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
 
Back
Top