Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-29-2015, 09:48 PM
PRA007's Avatar
PRA007 PRA007 is offline Find whether string contains hyperlink and Process the same Windows 7 64bit Find whether string contains hyperlink and Process the same Office 2010 32bit
Competent Performer
Find whether string contains hyperlink and Process the same
 
Join Date: Dec 2014
Location: Ahmedabad, Gujrat, India
Posts: 145
PRA007 is on a distinguished road
Default

Code was working fine till yesterday, but european patent office have changed their website overnight.

I will have to study the website now for the change have have made.
Reply With Quote
  #2  
Old 11-29-2015, 10:07 PM
macropod's Avatar
macropod macropod is offline Find whether string contains hyperlink and Process the same Windows 7 64bit Find whether string contains hyperlink and Process the same Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,521
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Quote:
Originally Posted by PRA007 View Post
Please note that some of my EP Links doesn't contain pdf doc.
It would have been helpful had you advised that beforehand. Try:
Code:
Sub EPHYPERLINKDOWN()
Application.ScreenUpdating = False
Dim StrTxt As String, HttpReq As Object, i As Long
Set HttpReq = CreateObject("Microsoft.XMLHTTP")
With ActiveDocument.Range
  With .Find
    .ClearFormatting
    .Replacement.ClearFormatting
    .Text = "EP [0-9]{5,} [0-9A-Z]{1,2}"
    .Replacement.Text = ""
    .Forward = True
    .Wrap = wdFindStop
    .Format = False
    .MatchWildcards = True
    .Execute
  End With
  Do While .Find.Found
    If .Hyperlinks.Count > 0 Then
      HttpReq.Open "GET", .Hyperlinks(1).Name, False
      HttpReq.Send
      StrTxt = HttpReq.ResponseText
      i = InStr(StrTxt, "https://data.epo.org/publication-server/pdf-document")
      If i > 0 Then
        StrTxt = Mid(StrTxt, i, Len(StrTxt) - i)
        i = InStr(InStr(StrTxt, ".pdf") + 3, StrTxt, ".pdf")
        If i > 0 Then
          StrTxt = Replace(Left(StrTxt, i + 3), "amp;", "")
          .Hyperlinks(1).Address = StrTxt
        End If
      End If
    End If
    .Collapse wdCollapseEnd
    .Find.Execute
  Loop
End With
Set HttpReq = Nothing
Application.ScreenUpdating = True
End Sub
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 11-29-2015, 11:24 PM
PRA007's Avatar
PRA007 PRA007 is offline Find whether string contains hyperlink and Process the same Windows 7 64bit Find whether string contains hyperlink and Process the same Office 2010 32bit
Competent Performer
Find whether string contains hyperlink and Process the same
 
Join Date: Dec 2014
Location: Ahmedabad, Gujrat, India
Posts: 145
PRA007 is on a distinguished road
Default

I will take care from next time.
Whenever I see opportunity of automation, I get excited and ask desperately, and forget to mention the conditions in fully.

As I have edited the post, You can now see what had happened with me.
EOP have changed the website
core of the website still works. I now need to generate hyperlink by my self from found text. I will update Accordingly.

I think with this code will solve my problem.
Reply With Quote
  #4  
Old 11-30-2015, 02:39 AM
PRA007's Avatar
PRA007 PRA007 is offline Find whether string contains hyperlink and Process the same Windows 7 64bit Find whether string contains hyperlink and Process the same Office 2010 32bit
Competent Performer
Find whether string contains hyperlink and Process the same
 
Join Date: Dec 2014
Location: Ahmedabad, Gujrat, India
Posts: 145
PRA007 is on a distinguished road
Default

One last Question in this thread.

I want to extract link similarly from following website.

view-source:https://patentscope.wipo.int/search/...b=PCTDocuments

Text I want is in following formate

"https://mirror.patentscope.wipo.int/patentscope/docservicepdf_pct_mirror/id00000031470708/PAMPH/WO2015177801.pdf"

I can find it using
Code:
"https://mirror.patentscope.wipo.int/patentscope/docservicepdf_pct_mirror/*.pdf"
Reply With Quote
  #5  
Old 11-30-2015, 08:05 AM
PRA007's Avatar
PRA007 PRA007 is offline Find whether string contains hyperlink and Process the same Windows 7 64bit Find whether string contains hyperlink and Process the same Office 2010 32bit
Competent Performer
Find whether string contains hyperlink and Process the same
 
Join Date: Dec 2014
Location: Ahmedabad, Gujrat, India
Posts: 145
PRA007 is on a distinguished road
Default

As this has answered my original question, Can be marked as solved, as the code does the job.
Reply With Quote
  #6  
Old 11-30-2015, 07:12 PM
macropod's Avatar
macropod macropod is offline Find whether string contains hyperlink and Process the same Windows 7 64bit Find whether string contains hyperlink and Process the same Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,521
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Quote:
Originally Posted by PRA007 View Post
As I have edited the post, You can now see what had happened with me.
EOP have changed the website
Please don't do that - changing posts that way after they've been replied to destroys the flow of the conversation in the thread. My reply to that post now doesn't make sense.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Tags
word vba

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Multiple Hyperlink to a single string PRA007 Word VBA 7 11-09-2015 04:29 PM
Find whether string contains hyperlink and Process the same find a set of characters in a string and return a 0 (zero) if not found MaineLady Excel 2 11-05-2015 03:23 PM
Find whether string contains hyperlink and Process the same Why is this Find string not working TechEd Word VBA 5 07-05-2014 08:12 PM
Find whether string contains hyperlink and Process the same Find and replace a string of text errtu Word 1 01-31-2013 02:09 PM
Find whether string contains hyperlink and Process the same Bad view when using Find and Find & Replace - Word places found string on top line paulkaye Word 4 12-06-2011 11:05 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:25 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