Can someone please advice me on how to open a website using VBA code?

[Aleng]

Hi,

I want code to open a web page then enter a word in textbox(looks like password field...no user name req) then click on OK (which is submit).


Any help will be really appriciated.
Aleng.

 

[procod]

You can do it in this way:

Sub submit_form()
Set ie = CreateObject("InternetExplorer.Application")
ie.Visible = True
ie.Navigate "http://www.somewhere.com"
While ie.busy
DoEvents
Wend
ie.Document.getElementById("password_textbox").Value = "secretpassword"
ie.Document.getElementById("submit_form").submit()
'or
ie.Document.getElementById("button_id").fireEvent("*******")
End Sub

I don't know why, but forum replaces "on click" (without space) with asterisks....