Import Text File from line number

[Urby1Kinobe]

Hi All,

Someone on this forum kindly helped by with this to bring in a text file to excel.

Please Login or Register  to view this content.

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

[mehmetcik]

Firstly. You must enclose your code within # tags.

Select edit, Select you code and then click on th # on the menu bar.

Try modifying your code like this:

Please Login or Register  to view this content.

The 8 is the number of lines to ignore.

[Urby1Kinobe]

Excellent, just tried it and works perfect

Thank you for the quick response

[mehmetcik]

Please Insert Your # Tags and mark this as solved.

[Marc L]

Hi,

Instead of this code, you can use Data, From a file (see QueryTables in VBA) …

[Urby1Kinobe]

How do i do the solved?

[shg]

Everything you need to know, including how to add CODE tags to your first post, is in the forum rules.