Read excel/text file thro VBA

[shabar]

Hi All



Is it possible to read text/excel file line by line thro VBA


Cheers


Shabar

[June7]

Sort of. This is a common topic. Search forum or Google. Code is different for text and Excel files.

[shabar]

Thax June7

I found following. It works for me

Dim FileName As String
Dim FileNum As Integer


Dim strTable, strColumn As String




FileName = "C:\Temp\TableName.txt"


FileNum = FreeFile()
Open FileName For Input As #FileNum


Do Until EOF(FileNum)
Input #FileNum, strTable, strColumn
Loop
Close #FileNum



Cheers

Shabar