Select Text Found in Word Document via Code Running in Excel

[XOR LX]

Hi all.

I'm currently having problems being able to select the text after finding it in a Word document. I'm running the code via Excel, and the following excerpt, for example, works fine:

Please Login or Register  to view this content.

(MyDoc is declared as Word.Document and is set via a WApp.Documents.Add procedure.)

However, I cannot manage to get the syntax correct to actually select the occurrence of the found string within the word document, so as to format it as I wish.

If I try, e.g.:

Please Login or Register  to view this content.

then this applies to the whole document, not just the selected text.

And if I try:

Please Login or Register  to view this content.

then the selection still applies to the active cell in the Excel sheet, not the Word document.

If it's important, then the lines immediately preceding these involve copying a section of text from the Excel document and pasting it into the Word document. The clipboard is not emptied.

Really appreciate any help, as always.

Cheers

[romperstomper]

Try:

Please Login or Register  to view this content.

Or you could use a Bookmark in Word so that you can put the text there directly and then simply format the bookmark's Range.

[XOR LX]

Thanks. So I have to reference via .Application - ah!

However, although I get no error, the found text is not formatted as requested. In fact, I can't find any occurrences of green text in the Word document, nor in the Excel document.

Is the string of the .Text parameter immediately transferred to becoming the .Selection, then, if found? It certainly isn't "selected" (=highlighted) as part of the process of running the code. What am I missing?

Re bookmarks, I've already used this for other parts of the code. This particular part, however, has to add some text in a position immediately after a variable-length piece of text has first been pasted in. I just used my example of colour-changing as an example: the basic gist is that I simply need to be able to make this search text (which is the final sentence in the pasted piece of text) the selection. Hopefully then I can work out how to move to a new line after that!

Cheers

[romperstomper]

If you paste it in, you should be able to determine the location of the text from that, I would think, then format directly. (Mind you, Word is not my thing - you should probably post this in the Word programming section so someone like macropod sees it)

[XOR LX]

Ok. Have done.

Cheers

[XOR LX]

Ok. I've manager to reference it correctly:

Please Login or Register  to view this content.

Now I just need to work out the code to go to the end of that search text and begin a new line!

Cheers

[romperstomper]

I think it would be something like:

Please Login or Register  to view this content.

[XOR LX]

Excellent!

That got me to the end of the selection. I can now add .InsertParagraphAfter and .InsertAfter, etc. and I think I'm on my way again!

Many thanks. Will mark as solved.

Cheers!