Hi All,
Someone on this forum kindly helped by with this to bring in a text file to excel.
Dim x As Double
Dim TXT As String
Open "C:\Users\Urby\Desktop\test.txt" For Input As #1
x = 0
Do While Not EOF(1)
Line Input #1, TXT
Cells(1, 1).Offset(x, 0) = TXT
x = x + 1
Loop
Close #1
I cannot seem to find the original post for some reason but i firstly wanted to thank them, but secondly ask if there was anyway i could add the import to only start at a different line of the text file rather than the top?
The text files I will want to import will have titles and headers on the first few lines then the data is from line 4 or 5, i would only like to bring in the data and not the headers/titles etc
Can anyone help?
Thank you
Bookmarks