I am going to try to explain this the best I can because I am out of ideas on making this work.
I get a report that comes out of an old banking system and it is compiled with some extra information that I always have to delete by hand - i do not want to do this any longer! Following are the steps that need to take place (i wish it was as simple as a loop) in order to get rid of the information.
Step 1. Delete everything from the first document line until "Header Text" (leaving the header text in tact)
Step 2. Delete everything from "Specific Wording" to next "Header Text" (leaving the header text in tact)
Step 3. Repeat step two
Step 4. Delete everything from "Specific Wording" to the very last line of the document.
The problem i am having is that I do not know how to delete using the "header" or "specific words". I think this is going to have to be the way it is done because the amount of other text in between each header and specific words varies considerably. I got the whole "find text" vba thing going, i just need to fill in the blanks.
Thanks
Bookmarks