Qfyilyi

I have some code that works fine to enter data via Excel/VBA into webforms.

I have it working on other sites, but on this one site, the data is "entered" into the text box, as I can see it on screen.

But if I then click on the text box the data disappears. Likewise, if I click submit on the form, I get an error saying the text boxes are empty (even though, on screen, they are not).

As I say, the code I have works on other sites so it must be something about the site I am using.

FYI here's simplified code I am using, where IE is an Internet Explorer object:

IE.document.all("EntryField_hdn_547").Value = "My Name"

This is the URL of the form:
https://public-online.hmrc.gov.uk/lc/content/xfaforms/profiles/forms.html?contentRoot=repository:///Applications/NICs_iForms/1.0/CA3822&template=CA3822.xdp

(you'll need to click through to the 3rd page, and click the "Employer" radio to see the text fields)

And this is the HTML of eg the above text entry box:

<input type="text" class="i" name="EntryField_hdn_547" tabindex="1469" aria-label="Name" style="text-align: left; vertical-align: middle; text-indent: 0px; padding: 0px 5.67px; height: 34.0157px; box-sizing: border-box; position: absolute; width: 566.93px;">

Can anyone help suggest a way to get the data to "stick" in the text boxes

(FYI I also have code to click the radio buttons, and that works fine)

Also, I tried this answer which seems very similar but still no joy:
Text entered into Webpage Search Box via Excel VBA is not detected when clicking Search button

This is dead easy with selenium basic. After install go VBE > Tools > References > Add a reference to selenium type library.

Option Explicit

Public Sub EnterInfo()

    Dim d As WebDriver

    Set d = New ChromeDriver

    Const url = "https://public-online.hmrc.gov.uk/lc/content/xfaforms/profiles/forms.html?contentRoot=repository:///Applications/NICs_iForms/1.0/CA3822&template=CA3822.xdp"



    With d

        .Start "Chrome"

        .get url

        .Window.Maximize

        '.ExecuteScript "window.scrollTo(0, document.body.scrollHeight);"

        .FindElementByCss(".S").Click

        .FindElementByCss("#_hdn_30 > div._.widget.buttonfieldwidget.xfaButton").Click

        .FindElementByCss("[aria-label=employer]").Click

        .FindElementByCss("[aria-label=Name]").SendKeys "Wile E. Coyote"

        .FindElementByCss("[aria-label='Name of company']").SendKeys "Acme Corporation"

        .FindElementByCss("[aria-label='Position in company']").SendKeys "Entrepreneur"

        .FindElementByCss("[aria-label='Telephone number']").SendKeys "012345678910"

        .FindElementByCss("[tabindex='1511']").Click

        .FindElementByCss("[tabindex='1537']").Click

        .FindElementByCss("#_hdn_653 > div._.widget.buttonfieldwidget.xfaButton").Click



         Stop



        .Quit

    End With

End Sub

QHarrs link provided the answer - by using SendKeys instead I could enter the data as text into the textboxes.

I did need to set the focus to IE first - I used the info here to get that bit sorted:
Set Focus to Internet Explorer Object in Visual Basic

ie

myIE.visible = false

DoEvents

myIE.visible = true