Textfile reader reading from 2 line and not the header row.

vba: excel  2010.

I need the following code to bypass line 1 so it does not read the HEADER ROW. Please.


What I need:
'Set up regex
Dim regEx
Set regEx = New RegExp
With regEx
    .MultiLine = False
    .Global = True
    .IgnoreCase = False
    .Pattern = "[^\x00-\x7F]" '<--pattern matching those pesky extended ASCII characters
End With

Do Until listFile.AtEndOfStream
    'Load up the line
    inLineRead = listFile.ReadLine
     
    
    'Get rid of extended ascii using the regex set up above
    inLineRead = regEx.Replace(inLineRead, "")
    
    'split the line, and write back out using the new delim
    inArrLine = Split(inLineRead, inDelim)
    
    'set some stuff for the loop
    firstField = True
    outLineWrite = ""
    outFieldNumber = 1
    
    'Loop through fields
    For Each inField In inArrLine
    
        'write out the value in the field
        If outFieldNumber <= numberOfFields Then
      'Add a delim if this isn't the first field
      If Not firstField Then
        outLineWrite = outLineWrite & outDelim
      Else
        firstField = False
      End If
            outLineWrite = outLineWrite & inField
        Else
            Exit For
        End If
    outFieldNumber = outFieldNumber + 1
    Next
        
    
    'Write it out only if there is something to write
    If Not Trim(outLineWrite) = "" Then writeFile.WriteLine outLineWrite
Loop

Open in new window

Thnks
fordraiders
LVL 3
FordraidersAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

aikimarkCommented:
Seems like more code than you actually need.  If you are using a textstream object, you can use its Skip method to skip the first line.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
FordraidersAuthor Commented:
Thanks
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.