+ Reply to Thread
Results 1 to 6 of 6

VBA: Pulling data from webpage

Hybrid View

  1. #1
    Registered User
    Join Date
    07-22-2019
    Location
    London
    MS-Off Ver
    2016
    Posts
    18

    VBA: Pulling data from webpage

    Hi everyone,

    I'm trying to pull data from a webpage into excel. I've used the 'New Query from Webpage' tool but it doesn't preview the page. I don't get any errors but also no data; I've attached 2 pictures of the information that the tool displays.
    I have succesfuly pulled data from this website before (different webpage) using this tool. Unfortunately I can't share the webpage as it is on our internal system.

    Does anyone have any other ideas on how I could pull the data from the webpage?

    Many thanks
    Attached Images Attached Images

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2407 (Windows 11 23H2 64-bit)
    Posts
    82,867

    Re: Pulling data from webpage

    There is an error message (on the right) and it tells you what the issue is.

    You need to speak to your IT team about the page using compatibility mode.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  3. #3
    Registered User
    Join Date
    07-22-2019
    Location
    London
    MS-Off Ver
    2016
    Posts
    18

    Re: Pulling data from webpage

    Thanks for the reply.
    Is there another way of pulling the data (VBA etc.)? I don't expect the team that manages this site are that inclined to change anything.

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2407 (Windows 11 23H2 64-bit)
    Posts
    82,867

    Re: Pulling data from webpage

    I don't know about VBA. Shall I move the thread to that section for you?

  5. #5
    Registered User
    Join Date
    07-22-2019
    Location
    London
    MS-Off Ver
    2016
    Posts
    18

    Re: Pulling data from webpage

    Yes, thank you

  6. #6
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2407 (Windows 11 23H2 64-bit)
    Posts
    82,867

    Re: VBA: Pulling data from webpage

    Thread moved.

+ 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. Pulling data from webpage
    By doublea17 in forum Excel General
    Replies: 1
    Last Post: 06-11-2014, 11:56 PM
  2. Pulling data from webpage
    By doublea17 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-11-2014, 02:47 PM
  3. Pulling specific data from webpage using excel macro
    By aserle in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-12-2013, 08:10 PM
  4. [SOLVED] Load webpage on TOPMAN website, extract prices from webpage into Spreadsheet
    By AKK9 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-04-2013, 11:49 AM
  5. Pulling a Specific Cell when Pulling a Tabel from Web Based Data
    By Zallen89 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-26-2013, 05:39 PM
  6. VBA - Pulling value from webpage?
    By tazrockon in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-20-2011, 09:13 PM
  7. Help With Macro Pulling Data from Webpage
    By Spreadsheet Surfer in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-27-2010, 12:56 PM

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