Search results

I've used several variation on the following: For x = 0 To 50 Debug.Print x & " - " & Me.EdgeBrowser0.RetrieveJavascriptValue("document.getElementsByTagName(" & Chr(34) & "button" & Chr(34) & ")[" & x & "].innerText") Debug.Print x & " - " &...

I did that that but couldn't find it. I will write a loop and see if that brings it up.

Can anyone help with how to click this button? It has no normal ID and I can't find it's position searching for the inner text. <input class="ipad-radio-btn-margin btn btn-default btn-largesize margin-right-5" data-ajax-url="/OPH/OphthalmicGosFour/SubmitSupplierDeclaration" data-btn-save=""...

I'm so stupid got it down to this, which does not generate an error: Me.EdgeBrowser0.ExecuteJavascript "document.getElementById(" & Chr(34) & ElementID & Chr(34) & ").value =" & Chr(34) & Login & Chr(34) & ";" but it wasn't updating. Of course after putting in a delay it worked. I forgot to...

I don't work directly for the NHS but this is a portal we use for certain NHS functions. I do have some API documentation somewhere. As for contacting the developers, that would be very difficult, as they don't even respond to general queries. One day I will have a better look at at the API...

I was writing a procedure usingVBA in access to use internet explorer. I have come up against an issue with compatibility which I will not be able to circumvent, and why am I using a depreciated browser? I had it largely working and am now trying to convert the code to work with an Edge browser...

Sorry I should have said this is a website form. I've added appactivate IE before the sendkeys and it appears to be working well. I wondered if could directly edit the html to remove the 'disabled="disabled"' from the locked controls, but don't know how to do this. Or how can I make my code...

I’m trying to complete a form where some elements are locked until others have been completed. When doing this manually just the act of typing something into the required fields unlocks the corresponding controls. For some reason entering the data like this doesn’t unlock the locked field...

I've been using: While IE.busy DoEvents Wend Loop between pages. although on initial load I use: Do Until IE.ReadyState = 4 And Not IE.busy DoEvents Loop I note if I interact with a page just after loading I get an error so have added: x = Timer + 2 Do While Timer < x DoEvents...

this is the button that opens the pop up address box <button class="btn btn-info ipad-Address-btn-margin" type="button" data-toggle="modal" data-target="#AddressModal" data-book-id="txtAddress">Please enter the address manually</button> I'm not really sure how to find out what changes when it...

Thanks again. I realised it does work. It just requires that the pop-up address window has been previously opened. If the AddNewAddress() function is called without first doing so, it does nothing. After opening and then closing the window (having previously populated it without opening it)...

yes. that when I noticed it triggered the function on the hidden box. I've tried variations of below but can't get it to work. IE.Document.parentWindow.execScript "AddNewAddress()"

typing it in gives: function AddNewAddress(){if(required()){if(CheckValidPostCode('Postcode')){var finalAddresss=GetAddressModaldata();var...

Amazing. Thank you very much, that works. That button is on a pop up form. I note to get it to work I have to make the form open and then click save, yet without the form open I can still insert data? Would it be possible to get it work with the form remaining hidden? Out of interest how would...

I've started using Set IE = CreateObject("InternetExplorer.Application") to try and control a webpage. Given IE is no longer supported, is it possible to do this using chrome or Edge?

Can anyone help with how to click this button using IE.document?

Also I'm trying to click this ckeckbox: '<input name="IsFirstTest" id="IsFirstTest" type="checkbox" value="true" data-val-required="The First test field is required." data-val="true" htmlattributes="{ id = cbkFirstTest, class = form-control }" data-group="cbTest"> I've tried using all of these...

Thanks again everyone. Is there a way using this code to read the entire page source/html into a string variable? I used to use the code below but it started getting blocked by the site I was querying. Dim winReq As Object Dim HTM, Address As Variant ' Set winReq = New...

Thanks. The elements didn't show up in the html, but using the tool you suggested revealed them and I have managed to enter data.

You can enter postcode and if you click the grey box a list of addresses drops down. If you click the manual address a pop up appears allowing you to enter the address. I tried to post the html, but it is too long. Is there a way to simulate key presses in IE? I can manually tab through the...