Hi All,
Someone on this forum kindly helped by with this to bring in a text file to excel.
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?![]()
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
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