[SOLVED]When importing .txt leave out several Rows

[Ravnoss]

Hi all,

I have a small problem, which I guess shouldn't be to hard to solve, but I have not been able to do so yet.
I Use the following Macro to import data from a .txt(As attached) into excel. This results in the also attached Excel sheet. I am almost happy with it, but I don't want the Return_number4501856 Totals row in there. As a matter of fact I don't want any break between the different return numbers. Does anyone know how to add this to the Macro?

Please Login or Register  to view this content.

[Richard Buttrey]

Hi,

The following macro should do it.

Please Login or Register  to view this content.

HTH

[Ravnoss]

Thanx, works like a charm.