+ Reply to Thread
Results 1 to 4 of 4

Dynamic Weblist(Dropdown) in web application

  1. #1
    Registered User
    Join Date
    08-13-2010
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003
    Posts
    4

    Dynamic Weblist(Dropdown) in web application

    Hi,

    I am working on this web application which has a dynamic drowdown.

    Its like this, If I choose a value in the first drop down in the webpage, the second drops displays the values according to the value chosen in the first dropdown.

    The problem is for the second dropdown the values are not show in the source code. The code that is dispalyed is
    HTML Code: 
    I am not sure how to choose the value in this second dropdown using VBA(Excel programming/Macro) since it is a dynamic dropdown.

    Suppose I want the Value "A" in the second dropdown, I have tried the code
    Please Login or Register  to view this content.
    But it doesn't seem to work.

    Any suggestions is welcome. Please help me out.

  2. #2
    Forum Expert romperstomper's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365, varying versions/builds
    Posts
    21,289

    Re: Dynamic Weblist(Dropdown) in web application

    Your post does not comply with Rule 8 of our Forum RULES. Cross-posting is when you post the same question in other forums on the web. You'll find people are disinclined to respond to cross-posts because they may be wasting their time solving a problem that has been solved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser)to the cross-post. Expect cross-posts without a link to be closed a message will be posted by the moderator explaining why. We are here to help so help us help you!

    Read this to understand why we ask you to do this.
    Remember what the dormouse said
    Feed your head

  3. #3
    Registered User
    Join Date
    08-13-2010
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003
    Posts
    4

    Re: Dynamic Weblist(Dropdown) in web application

    Yes I do understand this, only that I was not aware of the Rule.

    Here is the link to the cross post
    http://www.mrexcel.com/forum/showthr...15#post2410815

    Sorry about the Confusion.

  4. #4
    Forum Contributor
    Join Date
    07-13-2007
    Posts
    151

    Re: Dynamic Weblist(Dropdown) in web application

    You might want to try testing that element as an object to reveal other dimensions that may contain the values you seek. For example, try something like:

    Please Login or Register  to view this content.
    to see if that reveals anything. If so, then loop through all the Attribute Names to identify a portion of the object that sounds like a collection of other attributes. For example you may find something like "ListOptions". You could then loop enumerate the "ListOptions" collection for all of its contents.

    I just ran across a situation like this other day where the web page's data was only referred to in the HTML as a single line item similar to yours. Turns out that line represented an object, that had several properties I could query. After exploring that object's properties, I got to what I needed to scrape.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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