Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
SPLITTING DATA INTO NEW WORKSHEETS FROM ONE WORKSHEET | Excel Discussion (Misc queries) | |||
splitting a worksheet into multiple worksheets | Excel Discussion (Misc queries) | |||
Splitting a text file into individual worksheets | Excel Discussion (Misc queries) | |||
splitting data across worksheets | Excel Discussion (Misc queries) | |||
Searching Across Worksheets: Please help! | New Users to Excel |