+ Reply to Thread
Results 1 to 9 of 9

Web connect fails, web page rejects IE request

  1. #1
    Registered User
    Join Date
    01-09-2021
    Location
    VANCOUVER, CANADA
    MS-Off Ver
    2019
    Posts
    14

    Web connect fails, web page rejects IE request

    I am trying to get data from a web app which creates a table.
    When I try the "get data" function on excel it doesn't "see" the table, it sees an empty page as far as I can tell.

    What I want to do is for an excel sheet to go in every day at a certain time (which i saw can be done with the windows tasker) and run a macro which takes the column of data for "today" and adds it in a new column into the spreadsheet.

    The website for the web app is: " the system is not allowing me to put the link until i post a few times"

    The website that launches the web app is: **again, the system doesn't allow me to post the link** The information is for the fire danger rating in British Columbia Canada, for the northwest fire centre
    ***you need to click on one of the "Danger class report" at the bottom of the page, I click on the Northwest fire centre.

    Once I have this data I need to apply certain scenarios to it for warnings to pop up. But first I need to be able to auto update the data.

    Thank you in advance!
    Last edited by 6StringJazzer; 07-06-2022 at 03:45 PM.

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,703

    Re: Scrape information from a web app

    Try including a URL without any http:// in front. I am guessing this is what you're talking about:

    https://wfapps.nrs.gov.bc.ca/pub/wfw...0Fire%20Centre
    Jeff
    | | |·| |·| |·| |·| | |:| | |·| |·|
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Registered User
    Join Date
    01-09-2021
    Location
    VANCOUVER, CANADA
    MS-Off Ver
    2019
    Posts
    14

    Re: Scrape information from a web app

    YES! thats the one

  4. #4
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,703

    Re: Scrape information from a web app

    How specifically are you getting the data?

    Excel will use an Internet Explorer engine to retrieve web data. The web site does not like this:

    IE browser detected. Please use Chrome.

    It won't show you the data if you use IE. This might require HTTP coding in VBA to retrieve the data, but that might not work either. I have limited experience in retrieving web data, maybe someone else can contribute more.

  5. #5
    Registered User
    Join Date
    01-09-2021
    Location
    VANCOUVER, CANADA
    MS-Off Ver
    2019
    Posts
    14

    Re: Scrape information from a web app

    Thank you for your input, that's what happened to me, and i tired chrome and the same thing happened. so i don't know what the issue is.
    i want to add the data for "today" automatically to my excel table, but I have no clue how to go about it.

    My guess is the data gets generated and then persented but its not really in the table but in another "container" since you can find the data when you inspect the web page but then I dont know how to get excel to find the specific "td" of the table and copy and paste it

  6. #6
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,703

    Re: Scrape information from a web app

    I am changing your title so it better describes the problem. It might attract more attention.

  7. #7
    Registered User
    Join Date
    01-09-2021
    Location
    VANCOUVER, CANADA
    MS-Off Ver
    2019
    Posts
    14

    Re: Scrape information from a web app

    sounds great, I'm sure someone (with much more experience) has run into this before. hopefully they can help me

  8. #8
    Forum Contributor
    Join Date
    02-25-2022
    Location
    Dallas, Texas
    MS-Off Ver
    Office 365
    Posts
    174

    Re: Web connect fails, web page rejects IE request

    This example extracts the whole table but you can easily modify it to extract the column you want.

    Please Login or Register  to view this content.
    Attached Files Attached Files

  9. #9
    Registered User
    Join Date
    01-09-2021
    Location
    VANCOUVER, CANADA
    MS-Off Ver
    2019
    Posts
    14

    Re: Web connect fails, web page rejects IE request

    Thank you for this,

    Now I have some reading to do about the selenium driver! since I don't know what's going on in the code but now I know what I need to tweak since I have the code that works.

+ 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. Scrape webpages
    By beijing0305 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-12-2021, 01:17 PM
  2. Excel vba web scrape
    By prinsr in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 11-19-2019, 06:45 AM
  3. New to VBA need to scrape a folder for .jpg only.
    By PaulD81 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-11-2019, 06:57 AM
  4. How to scrape through VBA
    By Wheatly in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-13-2017, 05:21 PM
  5. [SOLVED] How to Scrape information from a website and put in specific column of existing worksheet.
    By Glove83 in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 10-22-2015, 11:44 AM
  6. Web Scrape
    By tobermory in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-17-2012, 10:32 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