View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.programming
ron ron is offline
external usenet poster
 
Posts: 118
Default How to access certain website log in with user name and passwordand click certain button?

On Jan 7, 7:51*am, geniusideas wrote:
On Jan 6, 12:39*am, ron wrote:

On Jan 5, 8:26*am, geniusideas wrote:


Dear AB,


The above code won't work, unable to load desire website. Totally
hang.
Please help.


What's the website url?..Ron


Any web also cannot, even u try google..


This works for Google log-in...Ron

Sub IE_Automation()

' Open the Google log-in web page
my_url = "https://www.google.com/accounts/ServiceLogin?
continue=http://www.google.com/ig% _
3Ftab%3Dgw%26hl%3Den&followup=http://www.google.com/
ig%3Ftab%3Dgw%26 _
hl
%3Den&service=ig&passive=true&cd=US&hl=en&nui=1&lt mpl=default"

Set ie = CreateObject("InternetExplorer.Application")
With ie
.Visible = True
.Navigate my_url
End With

' Loop until the page is fully loaded
Do Until ie.ReadyState = 4 And Not ie.Busy
DoEvents
Loop

' Log-in
Set ipf = ie.Document.all.Item("Email")
ipf.Value = "your e-mail address"

Set ipf = ie.Document.all.Item("Passwd")
ipf.Value = "your Google password"

Set ipf = ie.Document.getElementByID("signIn")
ipf.Click

' Loop until the page is fully loaded
Do Until ie.ReadyState = 4 And Not ie.Busy
DoEvents
Loop

' Now do whatever

End Sub