Thread: Trying to NOT import some records in a large text file
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Francois via OfficeKB.com Francois via OfficeKB.com is offline
external usenet poster
  
Posts: 109
Default Trying to NOT import some records in a large text file
Hi All,

I'm importing a large text file into Excel.(I have no control of the format
at source).

I'm trying to NOT import any records that start with AAJ and accept all
others, but I can't get the code to do what I'm trying to tell it.


Do until EOF(FNum)

Line Input #FNum,Inputline

'These are the lines that I want to NOT import
If Left(InputLine(,3)="AAJ" Then (How do I tell it to miss this record and
get the next one?)




loads more code here



Loop

Thanks in advance for any help

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200809/1

Reply With QuoteReply With Quote