Results 1 to 15 of 15

Web scraping question

Threaded View

  1. #1
    Registered User
    Join Date
    07-29-2018
    Location
    In the Queen's Shed
    MS-Off Ver
    2013
    Posts
    23

    Web scraping question

    This is giving me a headache. Below is my code. This forum does not let me post URLs, which is ever so silly. Where it says "URL =" in the code below, enter any (URL in quotation marks) from a bibliography page listed on espacenet, e.g. for patent Nr. KR20190082024.

    The responsetext seems to return the web page header, but of course I want to grab the body. Using the InternetExplorer.Application object is no option; this is slow and prone to error.

    Please help.

    Sub text()
    Dim WebQuery As New MSXML2.XMLHTTP60
    Dim URL As String
    
    ' URL added by mod
    URL = "https://worldwide.espacenet.com/publicationDetails/biblio?DB=EPODOC&II=0&ND=3&adjacent=true&locale=en_EP&FT=D&date=20190709&CC=KR&NR=20190082024A&KC=A#"
    
    WebQuery.Open "GET", URL, False
    
    WebQuery.send
    
    If WebQuery.Status <> 200 Then
        Cells(1,1) =  WebQuery.Status & " : " & WebQuery.StatusText
        Exit Sub
    End If
    
    Cells(1, 1) = WebQuery.ResponseText
    
    End Sub
    Last edited by 6StringJazzer; 06-11-2020 at 03:13 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Web scraping
    By vijay.jp in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-02-2015, 12:56 AM
  2. Web Scraping
    By Thomo88 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-29-2014, 07:21 AM
  3. Replies: 1
    Last Post: 02-17-2014, 11:21 PM
  4. VBA Web Scraping question - unable to refresh/update map
    By shahzeb in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-24-2014, 12:40 PM
  5. Web Scraping Question
    By vexel77 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-21-2013, 05:21 PM
  6. [SOLVED] Beginner question about scraping web pages with Excel VBA
    By sheilnaik in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-28-2013, 11:45 AM
  7. Web scraping
    By mickbarry in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-01-2006, 06:25 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1