+ Reply to Thread
Results 1 to 1 of 1

VBA Web Scraping question - unable to refresh/update map

  1. #1
    Registered User
    Join Date
    09-30-2013
    Location
    New york, NY
    MS-Off Ver
    Excel 2007
    Posts
    5

    VBA Web Scraping question - unable to refresh/update map

    Website: http://doubletree3.hilton.com/en/abo...ons/index.html

    I am trying to Select a Location in the drop down menu.. when I do it on the webpage, the map updates. However, when I use the code, I am able to update the drop down value but the map does not update. I am using the nested loop (objElementForm) to update the form once the drop-down value is updated ... but i get a prompt on the webpage saying...
    "Internal forms can not be handled by generated pages".

    Eventually, I would like to get a listing of all the hotels in a certain region. Any suggestions how I could proceed? Thanks!!



    Set objElement = .document.getElementsByTagName("select")
    For Each input_element In objElement
    If input_element.ID = "regionSelect" Then

    input_element.Value = 414

    Set objElementForm = .document.getElementsByTagName("form")
    For Each input_elementForm In objElementForm
    If input_elementForm.ID = "locations-regions-form" Then
    input_elementForm.submit
    End If
    Next input_elementForm

    Exit For
    End If
    Next input_element
    Last edited by shahzeb; 01-24-2014 at 12:42 PM.

+ 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. Web Scraping Question
    By vexel77 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-21-2013, 05:21 PM
  2. [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
  3. Replies: 1
    Last Post: 03-18-2013, 11:09 PM
  4. Update/Refresh button
    By ilovelagar in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-23-2009, 09:42 AM
  5. update/refresh problem
    By mordy12 in forum Excel General
    Replies: 1
    Last Post: 01-22-2007, 07:11 AM

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