tartanretriever
New Member
- Joined
- Jul 19, 2011
- Messages
- 2
Hi. I got a problem that I'm certain is solvable in VBA, I just don't have the chops to figure it out on my own.
I need to pull multiple (over 150) blocks of text that always occur between the same two words (in word 2003), and move them to adjoining cells in excel (2003)
I need to take a word document that reads:
textdontwant textdontwant textdontwant WORD1 text1 text1 text1 WORD2 textdontwant WORD1 text2 text2 text2 WORD2 textdontwant textdontwant WORD1 text text WORD2...
and dump it to an excel spreadsheet that would read:
cell 1 cell 2
---------------------+-------------------
text1 text1 text1 | text2 text2 text2
I need to pull multiple (over 150) blocks of text that always occur between the same two words (in word 2003), and move them to adjoining cells in excel (2003)
I need to take a word document that reads:
textdontwant textdontwant textdontwant WORD1 text1 text1 text1 WORD2 textdontwant WORD1 text2 text2 text2 WORD2 textdontwant textdontwant WORD1 text text WORD2...
and dump it to an excel spreadsheet that would read:
cell 1 cell 2
---------------------+-------------------
text1 text1 text1 | text2 text2 text2