Get value from the console during code execution in selenium vba

Question

I am trying to Debug.Print a value in the immediate window of an input text field so when found that this line can be executed in the console

document.querySelector("#txtCaptcha").value

I thought it may be useful for me if I could get that value into the immediate window I have tried such line but returned nothing in the immediate window (no error occurred but nothing in the immediate window)

Debug.Print .ExecuteScript("document.querySelector('#txtCaptcha').value;")

Simply I am searching for a way to be able to get the value from javascript command. I have no idea about javascript so I am stuck

Do you have any text field defined in your page with id txtCaptcha ? — Appu Mistri
– Appu Mistri, Commented Jul 18, 2019 at 5:43

QHarr · Accepted Answer · 2019-07-18 06:41:04Z

2

You are mixing HTMLDocument and Selenium examples in the above.

You cannot return text in either scenario from ExecuteScript (or execScript for IE) direct. Use your script to write the value to an existing node (or create a new one) and then read from that via DOM parser.

Dim s As String
s = "captcha = document.querySelector('#txtCaptcha').value;" & _
    "document.title = captcha;"

.ExecuteScript s
.FindElementByTag("Title").Text

But if FindElementById("txtCaptcha").Attribute("value") doesn't return the value I would be surprised if using javascript will. Though testing with javascript in browser using url from a prior question of yours does return the value.

edited Jul 18, 2019 at 6:41

answered Jul 18, 2019 at 6:26

QHarr

84.5k14 gold badges58 silver badges105 bronze badges

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

10 Comments

YasserKhalil Over a year ago

Thank you very much for great efforts. I encountered error at the last line so I changed to Debug.Print .FindElementByTag("Title").Text > but I got empty in the immediate window.

QHarr Over a year ago

I am not surprised. But the process in general above is correct for how to return from ExecuteScript.

QHarr Over a year ago

Side note: Have you checked btw your element is not inside an iframe? Because from your prior url it is.

YasserKhalil Over a year ago

Yes in the code I recognize it is in frame so I used .SwitchToFrame "searchCaseDiv"

QHarr Over a year ago

Use the iframe url direct. It works with IE pastebin.com/DkaT1LJr

|

William E · Accepted Answer · 2023-06-06 21:27:38Z

1

Just add return in front of your JS script.

Debug.Print .ExecuteScript("return document.querySelector('#txtCaptcha').value;")

answered Jun 6, 2023 at 21:27

William E

112 bronze badges

Collectives™ on Stack Overflow

Get value from the console during code execution in selenium vba

2 Answers 2

10 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

10 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related