Quote:
Originally Posted by PRA007
As part of long process, I want to find following string:
Code:
EP [0-9]{5,} [0-9A-Z]{1,2}
and if it contains hyperlink i would like to use that link to process it |
Unless 'EP 2614045 B1' is how the hyperlink is displayed in the document, your Find will not locate it. If the hyperlink looks like to one in your post, your Find will not locate that either, because there are other characters interspersed with them in the hyperlink (e.g. EP&pn=2614045&ki=B1). If you want to find strings like 'EP' and '2614045' and 'B1' in such a hyperlink, you'd need to use a Find expression like:
EP[!0-9]@[0-9]{7}[!0-9]@B1
Even then, all you'll have found is the part of the hyperlink containing EP 2614045 B1 - not the whole hyperlink.
As for your actual Find expression, that doesn't seem to have anything to do with the hyperlink you say you want to find, so I can't really understand what you're trying to do.
You also say you want to:
Quote:
|
remove original hyperlink with MsgBox Hyperlink
|
but you can't do that by inserting the text the message box displays - you need to actually create a hyperlink.