Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-10-2015, 09:55 PM
PRA007's Avatar
PRA007 PRA007 is offline How to insert hyperlink based on the text Windows 7 32bit How to insert hyperlink based on the text Office 2010 32bit
Competent Performer
How to insert hyperlink based on the text
 
Join Date: Dec 2014
Location: Ahmedabad, Gujrat, India
Posts: 145
PRA007 is on a distinguished road
Default Working Fine but I made mistake in asking.

Apology for not making it clear what I wanted.
Actually I want Original text to be intact. just want to insert hyperlink to the text (patent Numbers).
I made one more step after your macro, converted it back to the original text.

find what:
https://www.google.co.in/patents/([A-Z]{2})([0-9]{4,})([A-Z0-9]{1,2})?cl=en


Replaced with:
\1 \2 \3

Final text retained the link. Thanks
Reply With Quote
Reply

Tags
microsoft word, vba, wildcard



Similar Threads
Thread Thread Starter Forum Replies Last Post
VBA Search Table for Text/Select Text/Insert Hyperlink sldrellich Word VBA 3 03-24-2015 01:09 PM
Insert a hyperlink in body of email ChuckDrago Outlook 0 06-28-2013 06:51 AM
How to insert hyperlink based on the text Insert the Hyperlink and hide all sheets except clicking Hyperlink PRADEEPB270 Excel 1 02-22-2013 09:47 AM
Hyperlink/Data Insert & replace jclinton Word 1 09-19-2012 07:22 PM
Insert Hyperlink - Differing Functionality nell3773 Word 0 04-30-2010 12:23 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:15 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft