Results 1 to 23 of 23

Excel 2010 Select IE Dropdown

Threaded View

  1. #3
    Registered User
    Join Date
    12-12-2012
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    13

    Re: Excel 2010 Select IE Dropdown

    Not much so far, I'm stuck on this point...

    Sub PullData()
    ' Comment out the below line to stop pop-up box!
    ' MsgBox ("Be patient, the script will run after you click ok.")
    ' Reference MS Internet Controls
    
    ' Declare variables
        Dim IE As InternetExplorer
        Set IE = New InternetExplorer
        
    ' Navigate to correct page
        With IE
            .Visible = True
            .Navigate "website here"
        End With
    ' Wait for page to load - allows server to fail
        Application.Wait (Now + TimeValue("00:00:03"))
    ' Fill in the search form
        With IE
            .Document.form1   <<<stuck here
        End With
    
        With IE
            '.Quit
        End With
        
        Set IE = Nothing
    End Sub

    EDIT:
    Might be important to mention that the table output one the button is pressed will always be a different size
    Last edited by Jman12; 12-14-2012 at 09:33 PM. Reason: Forgot stuff

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