Searching a txt file for splitting into different worksheets

[Randy Reese]

Is it possible to write code that will take a 100 page txt file that has
several different fixed width sections and send them to different
worksheets. The Text file looks something like this:



Report for 1-19-2004
Section A
xxx xxxx xx xxxxxx xxxx xxxxxx xxx
xxx xxxx xx xxxxxx xxxx xxxxxx xxx
xxx xxxx xx xxxxxx xxxx xxxxxx xxx
end of section

Report for 1-19-2004
Section B
xxxxxx xxxx xxxx xxxxxxxxxx
xxxxxx xxxx xxxx xxxxxxxxxx
xxxxxx xxxx xxxx xxxxxxxxxx
xxxxxx xxxx xxxx xxxxxxxxxx
end of section

Report for 1-19-2004
Section C
xxx xxx xxx xxxxxx xxxx xxxxxxx xxx xxx
xxx xxx xxx xxxxxx xxxx xxxxxxx xxx xxx
xxx xxx xxx xxxxxx xxxx xxxxxxx xxx xxx
page break

Report for 1-19-2004
Section C
xxx xxx xxx xxxxxx xxxx xxxxxxx xxx xxx
xxx xxx xxx xxxxxx xxxx xxxxxxx xxx xxx
xxx xxx xxx xxxxxx xxxx xxxxxxx xxx xxx
end of section

 

[Tom Ogilvy]

Yes, you would just look for the word Section in the line you read in to
separate the sections.

You would want to do a sequential read:

http://support.microsoft.com/support/excel/content/fileio/fileio.asp
File Access with Visual Basic® for Applications