What do you actually want to do? Reading from or writing to a text file is
something Excel can do, for eaxmple the code below reads in 1 line at a time
from a text file and copies it to a worksheet.
Sub importtext()
x = 1
Open "c:\trial.txt" For Input As #1
Do While Not EOF(1)
Input #1, Line
Worksheets("sheet1").Cells(x, 1).Value = Line
x = x + 1
Loop
Close #1
End Sub
The text file is a report which contains telephone data. I need to take the
total number of calls received and answered from the file, and the date which
is in the file. The rest of the text in the file I don't need. Is there any
way of doing this with a formula as unfortunately I don't understand macro
coding.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
