+ Reply to Thread
Results 1 to 4 of 4

VBA / Web Automation / Finding child IE Window:

  1. #1
    Registered User
    Join Date
    02-02-2013
    Location
    texas
    MS-Off Ver
    Excel 2003/2010
    Posts
    59

    VBA / Web Automation / Finding child IE Window:

    Hey all,
    I am having some trouble getting VBA to focus on the IE child window after a link has been clicked.
    The 1st page i have automated like so:

    Please Login or Register  to view this content.
    The second page ("https://propaccess.trueautomation.com/clientdb/?cid=53"), if i just render this URL as the strUrl, then I can automate the 2nd page with this:
    Please Login or Register  to view this content.

    Where I am totally stuck: I cannot seem to figure out how to get them to work together?? Once the child IE window comes into play, how do i reference it?

    Parent WIndow = "http://staging.trueautomation.com/ta/index.php/PropertyAccess_noscript"
    Child Window = "https://propaccess.trueautomation.com/clientdb/?cid=53"
    Ultimately the Goal Window = "https://propaccess.trueautomation.com/clientdb/SearchResults.aspx"

    Any help, advice or suggestions would be greatly appreciated. Thanks!

  2. #2
    Registered User
    Join Date
    02-02-2013
    Location
    texas
    MS-Off Ver
    Excel 2003/2010
    Posts
    59

    Re: VBA / Web Automation / Finding child IE Window:

    Anyone? referencing the IE child window?? lol

  3. #3
    Valued Forum Contributor
    Join Date
    05-21-2009
    Location
    Great Britain
    MS-Off Ver
    Excel 2003
    Posts
    550

    Re: VBA / Web Automation / Finding child IE Window:

    Use IE WithEvents and trap the NewWindow2 event, or loop through Shell.Windows looking for an IE object which matches something in the child window, e.g. URL, location name, or something in the document.body content, etc.
    Post responsibly. Search for excelforum.com

  4. #4
    Registered User
    Join Date
    02-02-2013
    Location
    texas
    MS-Off Ver
    Excel 2003/2010
    Posts
    59

    Re: VBA / Web Automation / Finding child IE Window:

    It took a while, but i eventually figured it out. Thanks though

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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