IE.Document.getElementsByName("name").Value = "Value" not working

Question

When I try and do this, it throws a number of errors at me depending on other bits of my code, such as the method is not associated with that object or an unspecified error.

I am trying to go down a list of Excel cells with strings and use a web form to search for those strings.

My code currently looks like this:

Sub YSF_automation()
    Application.ScreenUpdating = False

    Set IE = CreateObject("InternetExplorer.Application")
    IE.Visible = True
    IE.Navigate "URL"

    While IE.Busy
        DoEvents
    Wend

    IE.Document.getElementsByName("ElementName")(0).Value = "test"

End Sub

Answer 1

Try the below

Option Explicit

Dim IE as Object

Sub YSF_automation()
    Application.ScreenUpdating = False

Set IE = CreateObject("InternetExplorer.Application")
IE.Visible = True
IE.Navigate "URL"

While IE.Busy
    DoEvents
Wend

set document = IE.document
with document
    .getElementsByName("ElementName")(0).value="test"
end with
End Sub