Retrieving data from an edge browser window

[wackywoo105]

I'm trying to retrieve the value of this element, but I can't figure out how.

<input autocomplete="off" class="form-control w84 h25 display-inline-block" id="SupplierModel_TotalClaimForGlassesOrContactLenses" maxlength="6" name="SupplierModel.TotalClaimForGlassesOrContactLenses" placeholder="£ 0.00" readonly="readonly" style="text-align:right" type="text" value="">

I've tried this but it doesn't work:

Debug.Print Me.EdgeBrowser0.ExecuteJavascript; "document.getElementById('SupplierModel.TotalClaimForGlassesOrContactLenses').value"

Can anyone please help?

 

[cheekybuddha]

Debug.Print Me.EdgeBrowser0.ExecuteJavascript; "document.getElementById('SupplierModel.TotalClaimForGlassesOrContactLenses').value"
                                                                                      ^
                                                                                      |
                                                                        The id of the input has an
                                                                        underscore (_) here, not a
                                                                        dot (.)

 

[wackywoo105]

Debug.Print Me.EdgeBrowser0.ExecuteJavascript; "document.getElementById('SupplierModel.TotalClaimForGlassesOrContactLenses').value"
                                                                                      ^
                                                                                      |
                                                                        The id of the input has an
                                                                        underscore (_) here, not a
                                                                        dot (.)

Sorry. I did actually try with the underscore. that was just an error in typing out the question. I get this:

 

[cheekybuddha]

Remove the semi-colon after .ExecuteJavascript

 

[wackywoo105]

Remove the semi-colon after .ExecuteJavascript

Thanks for your help. I can't remove the semi-colon as it's automatically added back.

 

[Gasman]

Thanks for your help. I can't remove the semi-colon as it's automatically added back.

Put it at the end of the line?

 

[cheekybuddha]

it must be a function rather than a sub.

try:

Debug.Print Me.EdgeBrowser0.ExecuteJavascript("document.getElementById('SupplierModel_TotalClaimForGlassesOrContactLenses').value")

 

[cheekybuddha]

Are you sure that you are using the correct function for the job?

EdgeBrowser control docs

I think you might actually need RetrieveJavascriptValue instead.

What happens if you try:

Dim JStoExecute As String, result As String

JStoExecute = "document.getElementById('SupplierModel_TotalClaimForGlassesOrContactLenses').value"
result = Me.EdgeBrowser0.RetrieveJavascriptValue(JStoExecute)
Debug.Print result

 

[cheekybuddha]

If the above fails, you can also try adjusting JStoExecute to be a function:

' ...
JStoExecute = "() => document.getElementById('SupplierModel_TotalClaimForGlassesOrContactLenses').value"
' ...

 

[wackywoo105]

Are you sure that you are using the correct function for the job?

EdgeBrowser control docs

I think you might actually need RetrieveJavascriptValue instead.

What happens if you try:

Dim JStoExecute As String, result As String

JStoExecute = "document.getElementById('SupplierModel_TotalClaimForGlassesOrContactLenses').value"
result = Me.EdgeBrowser0.RetrieveJavascriptValue(JStoExecute)
Debug.Print result

Many thanks. That works.