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>
Bookmarks