IE.Document.getElementById("ID") not working!

I am trying to automate Internet Explorer using vba.

1. I connect to www.google.com (this works fine)
... commands :
Set IE = CreateObject("InternetExplorer.Application")
IE.Navigate ("http://www.google.com")


2. I try to select the google search box and to type in "Searchstring" (this does not work)
... command:
IE.Document.getElementById("lst-ib").Value = "Searchstring"


... For some reason the command "getElementById" does not work ... neither on google nor on any other website I tried ... but the command is correct ... I copied it directly from a youtube video ....

What is going on here? Help would be much appreciated!

Thank you for your reply ...
I had also tried the following code:
Dim a As Object
Set a = IE.Document.getElementById("lst-ib")
a.Value = "Searchstring"

This didn't work either (and according to the youtube video I watched, setting it as an object is not necessary either ... in the video it just worked with the following command: IE.Document.getElementById("ID").Value = "string")

Could you tell me where is the link?
Follow-up lines

Please Login or Register  to view this content.

Hi AB33,

here's the link to the video:

https://www.youtube.com/watch?v=q7aa76YFFW8

Not all HTML coding or sites are the same. In Google case, you have a form, so you need to give a value to the form and then submit it.

Hallo Leith Ross,

your code created an error message:

"Method 'Busy' of object 'IWebBrowser2' failed"

Hallo Leith Ross,

I also tried to use the code from the following video, which also uses google:
https://www.youtube.com/watch?v=GswfT0Mrr5M

But when I ran the exact same code (IE.Document.all("q").Value = "TestString"), it still did not put "TestString" into the google search box.

Since only excel and IE are involved in this task, why would defragmenting my drive and registry help?

Ultimately, I want to log in to another page and download data from there to excel ... google was just an example that I used to test the code ... is it possible that my company's IT department's security settings prevent me from using the code necessary for web scraping?

Anything is possible.

Can you share the other page and data you want to get to excel?

https://www.moodys.com/

... I want to automatically fill in my username and password ... but I am not able to "catch" this stupid textbox ...

Thank you for the code JasperD,


.... unfortunately it didn't work either. .... my computer must be cursed or sth. ... these web scraping things simply do not work on this computer.

Well, it should log you in, providing you put your username and password in the code.

What responsetext do you get (debug.print moodys.responsetext)? I obviously get a "not logged in one", but do you get the same as below?

{"passwordSharing":0,"isLoggedIn":false,"isLinked":false,"userId":null,"redirectUrl":null,"notify":null,"error":"A Username and Password are required for access to Moodys.com.","style":"WarningMessage"}

I put my username and password in the code. ... I do not get any response ...

I found the reason why it didn't work ... my company's IT Department has disabled the web scraping functions ... Thank you all for your help ... because your code failed as well, I got the idea that it was all about the configurations set by the IT department ... this idea was confirmed today by IT.

Thanks for the update.
However, if you can reach it via IE, then it should be doable via VBA... just saying ;-)

Alert me | Edit | Delete | Change type
Question
You cannot vote on your own post
0
PLease help!!!

Sub IE_Autiomation()
Dim ie As InternetExplorerMedium
Dim OrgBox As HTMLInputElement

url = ""

Set ie = New InternetExplorerMedium
ie.Visible = True
ie.Navigate url
Do
If ie.ReadyState = 4 Then
Exit Do
Else
DoEvents
End If
Loop

Set doc = ie.Document

ie.Document.getElementById("cxn-additem-btn").Click '' works fine
ie.Document.getElementById("cxn-add-btn").Click ''works fine
Set OrgBox = ie.Document.getElementById("pin-url") ''Issue is here
OrgBox.Value = "Hello"
I am getting error 424 object required.. I am running code using F8(manually). Page loading is taken care.

Please let me know if you find any solution for this