+ Reply to Thread
Results 1 to 3 of 3

query to web link does not return the table as before instead a message

  1. #1
    Registered User
    Join Date
    11-29-2010
    Location
    San Diego CA
    MS-Off Ver
    office 365
    Posts
    3

    query to web link does not return the table as before instead a message

    The following code has copied a table from a yahoo link for the last few years with no problem. I ran the code recently and instead of the table of players as before I received this message in a cell in my sheet.
    “It appears your browser may be outdated. For the best website experience, we recommend updating your browser. learn more”
    I tried the code with Google Chrome as my default browser instead of Internet Explorer with the same results.
    This is the code:
    Private Sub get_data_from_yahoo()
    '
    ' this will query yahoo and get scores for tournament
    With Sheets("players scores").QueryTables.Add(Connection:= _
    "URL;http://sports.yahoo.com/golf/pga/leaderboard?sort=name", _
    Destination:=Range("$U$3"))
    .BackgroundQuery = True
    .TablesOnlyFromHTML = True
    .Refresh BackgroundQuery:=False
    .SaveData = True
    End With
    End Sub
    Any thought would be appreciated

  2. #2
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: query to web link does not return the table as before instead a message

    It looks like a table, but it is not. I think the data are embedded in JavaScript.

  3. #3
    Registered User
    Join Date
    11-29-2010
    Location
    San Diego CA
    MS-Off Ver
    office 365
    Posts
    3

    Re: query to web link does not return the table as before instead a message

    They must have changed the site. It use to return the table. Thanks for your help

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Loop over all queries and return first column of each query in consolidated table
    By learning_vba in forum Access Tables & Databases
    Replies: 2
    Last Post: 01-03-2014, 10:19 AM
  2. VBA Web Query that gets data from a link not a table
    By jd01442 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-30-2013, 01:15 PM
  3. Can Excel link a query or code to pull pivot table report data
    By Miskondukt in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-06-2013, 04:57 PM
  4. [SOLVED] How to pop up a warning message before any Excel automatic update link reminder message
    By billj in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-01-2013, 10:41 AM
  5. Replies: 0
    Last Post: 12-05-2012, 03:48 PM
  6. VBA Open Text File <Missing Link> Query Table + Extras
    By duncanm82 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-24-2012, 04:56 PM
  7. Query a table and return results into my Excel Form
    By johncassell in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-15-2007, 07:41 AM
  8. [SOLVED] Syntax Error - Using Microsoft Query and ODBC link to a table
    By James T in forum Excel General
    Replies: 0
    Last Post: 08-30-2005, 10:05 PM

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