Guest User

Untitled

a guest
May 25th, 2018
81
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.45 KB | None | 0 0
  1. <input name="Action" onclick="this.disabled=true; this.form.submit();" type="submit" value="Search">
  2.  
  3.  
  4. Sub autoIE()
  5.  
  6. Dim IE As Object
  7. Set IE = CreateObject("InternetExplorer.Application")
  8.  
  9. IE.navigate "webpage.com"
  10.  
  11. IE.Visible = True
  12.  
  13. While IE.Busy
  14. DoEvents
  15. Wend
  16.  
  17. IE.document.all("lookupNumberId").Value = ThisWorkbook.Sheets("Sheet1").Range("a1")
  18.  
  19. IE.document.all("Action").Click 'error 438
  20.  
  21. IE.document.getElementByName("Action").Click 'error 438
  22.  
  23. End Sub
Add Comment
Please, Sign In to add comment