+ Reply to Thread
Results 1 to 4 of 4

Help to scrape website by choosing date from dropdown attribute

  1. #1
    Registered User
    Join Date
    03-30-2016
    Location
    Georgia
    MS-Off Ver
    ms office 2010
    Posts
    55

    Help to scrape website by choosing date from dropdown attribute

    Hello,
    Please help, I cant make it work
    there is a website which I connect using VPN from USA IP
    but thing is that there is dropdown object which needs to be chosen and then data will be displayed, I have most of the code for formatting or getting table but cant make it work to choose date from dropdown,
    Please help
    here is the website and the code
    https://wm.watchsystems.com/stpsociv...lestatesl.html

    Please Login or Register  to view this content.
    Last edited by stolba; 07-02-2019 at 08:37 AM.

  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. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,791

    Re: Help to scrape website by choosing date from dropdown attribute

    Administrative Note:

    We would very much like to help you with your query, however you need to include code tags around your code.

    Please take a moment to add the tags. Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

    Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

    (Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)
    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
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    MS365 Apps for enterprise
    Posts
    5,885

    Re: Help to scrape website by choosing date from dropdown attribute

    Here's sample code for specifying the frame and selecting first option available from dropdown.

    Please Login or Register  to view this content.
    Few notes:
    1. Above code uses late binding with no reference to InternetControls
    2. Site uses frames and since there are no id assigned to each frame, just use the frame src. Which is .asp page.
    3. You can use .document.getElementsbyTagName("option") to find list of available dates
    ?Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.?
    ― Robert A. Heinlein

  4. #4
    Registered User
    Join Date
    03-30-2016
    Location
    Georgia
    MS-Off Ver
    ms office 2010
    Posts
    55

    Re: Help to scrape website by choosing date from dropdown attribute

    Thanks, that helped, made loop through each date and successfully scraped every field necessary

+ 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] how to scrape a website that you have to log in to?
    By dmcgov in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-12-2018, 09:39 AM
  2. [SOLVED] VBA scrape data from website HTML
    By Strutland in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 02-11-2017, 06:18 PM
  3. Scrape website using VBA
    By cfcMalky in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-26-2014, 08:59 PM
  4. Scrape, pull or get data from a Website into Excel Please help me out
    By baig123 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-21-2014, 01:42 PM
  5. VBA Macro to Scrape Website - Post to Javascript
    By shahzeb in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-21-2014, 05:53 PM
  6. [SOLVED] Pull Specific Data from Website (Screen Scrape)
    By CHRISEWRIGHT20 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 12-11-2012, 11:03 AM
  7. VBA to scrape data from website
    By jdub22cb in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-16-2012, 04:00 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