| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Text Import Wizard (use for large files) | Excel Discussion (Misc queries) | |||
| very large text and CONTINUE records | Excel Programming | |||
| Import Text file into Excel and match up records | Excel Discussion (Misc queries) | |||
| how do I import a large amount of text into one cell? | Excel Discussion (Misc queries) | |||
| Error in large file import macro | Excel Programming | |||
Threaded Mode
