Help!!VBA question,How to control a .txt text file in Excel??

Question

Dear friend,if you're familiar with VBA,please help me in this case. How to control a .txt file in Excel's VBA function?
I don't find any API of VBA for text file, just as we do such as :
set ppt as PowerPoint.application
However I dont know which macro class is designed for .txt file,
Could anybody told me how?? Given codes is perfect!

Answer 1

You should be fine to use any VB api...Below is the code you require. I tested it using a file on C drive called Demo.txt.

Sub ShowFileContent()
Dim objLineText As String
Dim objCurrLine As Integer
objCurrLine = 0
Open "C:\Demo.txt" For Input As #1
Do Until EOF(1)
Input #1, objLineText
MsgBox "Line " & objCurrLine & " - " & objLineText
objCurrLine = objCurrLine + 1
Loop
Close #1
End Sub

Answer 2

Open Excel first. Open the .txt document from the document menu. stick to the import education. make positive you examine Delimited click next elect the nature that delimits the columns click end Voila - you've imported your first actual delimited textual content document.

Answer 3

You can get some help from
http://expert.myitcareer.org/