Excel Use Word to Find Text and return the following 10 characters

[baggieade]

Hi

I have a Macro which will open a word document, find some text and then replace it.

I would like to change it so that it finds the text and then simply record that text with the next 10 characters in a spreadsheet.

I want to find all 0845 numbers in word documents on a network drive and find out what the rest of the telephone number is.

This is my current code which is performing the find text count and then only making changes to the document if the text is found.

Please Login or Register  to view this content.

Moderator's note: Please take the time to review our rules. There aren't many, and they are all important. Rule #3 requires code tags. I have added them for you this time because you are a new member. --6StringJazzer