How to click HREF using Selenium

Question

Trying to click a download button on Chrome using Selenium Type Library. The code below is one that I picked up off the boards but I am receiving a Syntax Error

Sub Test()
Dim bot
Set bot = CreateObject("Selenium.WebDriver")

bot.Start "Chrome", "https://www.afterpaytouch.com"
bot.get "/results-reports"

bot.findElement(By.linkText("https://www.afterpaytouch.com/images/28082019-FY2019-Results-Presentation.pdf")).click()

End Sub

You probably want to dim bot as an` Object` instead of an assumed Variant, but that probably will not fix the problem. Please explain what line you are getting the error on. You forgot to include that in your question. — braX
– braX, Commented Nov 29, 2019 at 23:27
The error is on the bot.FindElement line - I can open the webpage fine but cannot click the download button — Mturks83
– Mturks83, Commented Nov 29, 2019 at 23:35
instead of trying to click it all in one line, set the element to a variable first, and then check to see if the variable gets set to something first. If not, then it could not find the element. My best guess is that you do not want to include the entire path to the element. - techbeamers.com/findelement-and-findelements-commands-examples — braX
– braX, Commented Nov 29, 2019 at 23:44
Tried the set the element as a variable but I am receiving a 'Sub or Function not defined error' ```Sub Test() Dim bot Set bot = CreateObject("Selenium.WebDriver") Dim Element Set Element = FindElement(By.linkText("afterpaytouch.com/images/…)) — Mturks83
– Mturks83, Commented Nov 30, 2019 at 0:16

QHarr · Accepted Answer · 2019-11-30 10:20:30Z

1

I would add a reference to Selenium Type Library in VBE > Tools > References then use early bound reference, full url and apply VBA selenium basic syntax to find link by css and click

Option Explicit

Public Sub Test()
 Dim bot As WebDriver
    Set bot = New ChromeDriver

    With bot
        .Start "Chrome"
        .get "https://www.afterpaytouch.com/results-reports"
        .FindElementByCss("[href='https://www.afterpaytouch.com/images/28082019-FY2019-Results-Presentation.pdf']").Click
        Stop '<delete me later
    End With
End Sub

answered Nov 30, 2019 at 10:20

QHarr

84.5k14 gold badges58 silver badges105 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to click HREF using Selenium

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related