Update Value of Web Page via Excel Macro

[Mark123456789]

Hello

I have been fighting with a problem for a while with no success.

I want to update a field on a webpage via excel vba.

I am using IE11.

Below is a picture of the source code of the page in question.

I want to update the Value from 29 to 31 for example.

I have tried getelementsby ID or tagname none of which works.

Can anyone help?

Thank you

updatevis.JPG

[Marc L]

Hi !

As getElementsByID should work …

[Mark123456789]

Hi Marc

I have tried it doesnt.

The code i am using is as follows:-

IE.document.getElementsByID("Input_Value").Value = 31

The error i get is Run time error 438, Object doesnt support this property or method.

Full code it shown below:-



Sub Help()

Dim IE As Object
'Dim doc As HTMLDocument
Set IE = CreateObject("InternetExplorer.Application")

IE.Visible = True
IE.Navigate "https://xxxxxxxxxxxxxxx"

Do While IE.Busy
Application.Wait DateAdd("s", 1, Now)
Loop

IE.document.getElementsByID("Input_Value").Value = 31

End Sub





What am i doing wrong

[Marc L]

Difficult to guess with no webpage access …