View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Randy Reese Randy Reese is offline
external usenet poster
 
Posts: 14
Default Searching a txt file for splitting into different worksheets

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