How do I click a link on a web page using Excel VBA?

by

Try getting the collection of anchor tags, with:

GetElementsByTagName("a")

Then, iterate that collection using as much logic as you can to ensure you’re clicking the right button.

For each l in ie.document.getElementsByTagName("a") 
    If l.ClassName = "hqt_button" Then
        l.Click
        Exit For
    Next

If there are multiple anchors with the same classname, you could do:

    If l.ClassName = "hqt_button" AND l.Href = ""https://stackoverflow.com/questions/24638533/javascript:void(0): onclick=HeaderBox.trySubmit()" Then
        l.Click
        Exit For
    Next

Alternatively

If you are using IE9+ you could use the GetElementsByClassName method.

GetElementsByClassName("hqt_button")

More Related Contents:

  1. How to import a table from web page (with “div class”) to excel?
  2. Print function selecting wrong Type of Change option excel vba
  3. Format Cell Contents
  4. Excel formula checklist in employees
  5. How do I put double quotes in a string in vba?
  6. What is the difference between .text, .value, and .value2?
  7. How can I URL encode a string in Excel VBA?
  8. What is the difference between “Form Controls” and “ActiveX Control” in Excel 2010?
  9. Check if the file exists using VBA
  10. How can I create a progress bar in Excel VBA?
  11. VBA rounding problem
  12. Pasting an Excel range into an email as a picture
  13. Excel VBA to Export Selected Sheets to PDF
  14. 2 ways for “ClearContents” on VBA Excel, but 1 work fine. Why? [duplicate]
  15. Excel 2013 VBA Clear All Filters macro
  16. Rounding in MS Access
  17. Count unique values in Excel
  18. Sum function in VBA
  19. Excel error 1004 “Unable to get …. property of WorksheetFunction class” appearing inconsistently
  20. How can I install/use “Scripting.FileSystemObject” in Excel 2010 for MAC?
  21. How to save Excel Workbook to Desktop regardless of user?
  22. How to add an attachment to an email using VBA in Excel
  23. Get Timezone Information in VBA (Excel)
  24. How to change Format of a Cell to Text using VBA
  25. How to extract text within a string of text
  26. GET pictures from a url and then rename the picture
  27. Create folder path if does not exist (saving from VBA)
  28. Concatenate multiple ranges using vba
  29. How to highlight selected text within excel
  30. How to fix a VBA “type mismatch” error after switching to 64-bit Excel

Leave a Comment