Advertisement
Guest User

Untitled

a guest
Jun 16th, 2019
79
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.65 KB | None | 0 0
  1. Sub Create_Change()
  2. Dim i As Long
  3. Dim URL As String
  4. Dim IE As Object
  5. Dim objElement As Object
  6. Dim objCollection As Object
  7. Dim HWNDSrc As Long
  8. Set IE = CreateObject("InternetExplorer.Application")
  9. IE.Visible = True
  10. URL = "URL to Navigate"
  11. IE.Navigate URL
  12. Application.StatusBar = URL & " is loading. Please wait..."
  13. Do While IE.ReadyState = 4: DoEvents: Loop
  14. Do Until IE.ReadyState = 4: DoEvents: Loop
  15. Application.StatusBar = URL & " Loaded"
  16. ' IE.Document.All("Search for a template").Value = "text to search"
  17. Set IE = Nothing
  18. Set objElement = Nothing
  19. Set objCollection = Nothing
  20. End Sub
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement