Results 1 to 4 of 4

Clicking a submit button after macro opens webpage.

Threaded View

  1. #1
    Forum Contributor
    Join Date
    05-19-2010
    Location
    Phoenix, AZ
    MS-Off Ver
    Excel 2003
    Posts
    107

    Clicking a submit button after macro opens webpage.

    Afternoon All,
    I have spent hours trying different ways to get this to work and I just can't figure it out.

    I currently have a macro that opens up Internet Explorer to a webpage that I need info from. I then need it to click the submit button at the bottom to run the report. This is an internal website that houses volume data. I can not link straight to the webpage I need. When I try it says for security reasons you can not go straight to the pages you need to access through the website. So i have gotten it to open up the webpage I need all I need now is for the submit button to be pressed to load the report.

    Here is my current code:

    Sub Websearching()
    
    Dim ie As Object
    
    
    Set ie = CreateObject("INTERNETEXPLORER.APPLICATION")
    ie.NAVIGATE "http://fraud.intra.aexp.com/trpts/trpt3.asp"
    ie.Visible = True
    
    
    While ie.busy
    DoEvents
    Wend
    
    End Sub
    Here is the HTML Code for the button on the website:


     <td> 
              <div align="center"><font color="#008080"> 
                <input type="submit" value="Run Report" class="SubmitButton"  id="submit1" name="submit1">
                </font></div>
            </td>
    Last edited by CJPHX; 07-09-2010 at 09:48 AM.

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