LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Going to website & Entering username & password [email protected] Excel Programming 3 June 28th 10 03:48 PM
ADO / Excel & Access: User ID and Password Santiago[_2_] Excel Programming 0 August 5th 05 09:22 PM
User name button access. sungen99[_23_] Excel Programming 2 August 4th 05 09:15 PM
Password on Website Mohammed Wadood Excel Programming 0 December 23rd 04 05:36 PM
User name & password access to Excel files in a folder Maria[_6_] Excel Programming 4 November 17th 03 06:44 PM


All times are GMT +1. The time now is 11:49 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"