Guest User

Untitled

a guest
Jan 18th, 2019
68
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.48 KB | None | 0 0
  1. Sub Orion()
  2.  
  3. Dim IE As Object
  4. Dim doc As HTMLDocument
  5. Set IE = CreateObject("InternetExplorer.Application")
  6. Set IE = New InternetExplorerMedium
  7.  
  8. IE.Visible = True
  9. IE.navigate "http://aporion.lear.com/Orion/Nodes/Default.aspx"
  10.  
  11. Do While IE.Busy
  12. Application.Wait DateAdd("s", 1, Now)
  13. Loop
  14.  
  15. Set doc = IE.document
  16.  
  17. doc.getElementById("search").Value = ThisWorkbook.Sheets("Data").Range("A1").Value
  18.  
  19. IE.doc.getElementsbyClassName("sw-btn-t")(0)
  20.  
  21. span class="sw-btn-t"Search/span>
Add Comment
Please, Sign In to add comment