VBA with selenium throws element not visible error

Question

Upon running my script , I get stuck with element not visible error in vba with selenium. Here is the code I was trying with:

Sub Table_stuff()

Dim driver As New WebDriver

With driver
    .Start "chrome", "http://apps.tga.gov.au/Prod/devices"
    .get "/daen-entry.aspx"
    .Timeouts.PageLoad = 20000
    .FindElementById("disclaimer-accept").Click
    .Timeouts.PageLoad = 20000
    .FindElementById("medicine-name").SendKeys ("pump") ''Error thrown here
    .FindElementById("medicines-header-text").Click
    .FindElementById("submit-button").Click
    .Timeouts.PageLoad = 20000
End With
End Sub

Here is the element reaching where my scraper throws that specific error:

<input type="text" name="medicine-name" id="medicine-name" value="" 
placeholder="Type at least 3 characters" title="Enter medical device name" 
autocomplete="off" maxlength="100" class="placeholder" style="color: rgb(0, 0, 0);">

Is the element actually visible in a browser?

Tim Williams
– Tim Williams

2017-07-09 22:53:21 +00:00
Commented Jul 9, 2017 at 22:53 — Tim Williams
– Tim Williams, Commented Jul 9, 2017 at 22:53
Yep, element is visible in the browser.

SIM
– SIM

2017-07-09 23:10:43 +00:00
Commented Jul 9, 2017 at 23:10 — SIM
– SIM, Commented Jul 9, 2017 at 23:10

alecxe · Accepted Answer · 2017-07-10 00:28:44Z

2

From what I understand Timeouts.PageLoad call would not actually trigger selenium driver to wait - I think it just sets a page load timeout. Which means that your code would try to send keys to the search input at the moment of the opened license dialog - which triggers the "element not visible" error.

What you need is a Wait call (well, ideally an Explicit Wait, but I am not sure if VBA bindings have that functionality):

.Wait 3000  ''3 seconds

answered Jul 10, 2017 at 0:28

alecxe

476k127 gold badges1.1k silver badges1.2k bronze badges

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

Comments

JohnM · Accepted Answer · 2023-09-23 08:37:27Z

1

Replacing FindById with XPath to get the title, which accepts input, should work.

Here is the code snippet:

.FindElementByXPath("//input[@title='Enter medical device name']").SendKeys ("pump")

edited Sep 23, 2023 at 8:37

JohnM

3,3904 gold badges13 silver badges29 bronze badges

answered Sep 22, 2023 at 23:40

Jens

1111 bronze badge

Collectives™ on Stack Overflow

VBA with selenium throws element not visible error

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related