-
Solved: www.youtube.com
The userform and password are not real but for some reason after looking at the source code I cannot get this part right
With IE.Document.Forms("loginForm")
.Item("username").Value = MyLogin
.Item("password").Value = MyPass
.Submit
End With
Here is the code:
[vba]Sub IE_login()
Dim IE As Object, MyPass As String, MyLogin As String
Do
MyLogin = "xxxxx"
MyPass = "xxxxx"
Loop Until Len(MyLogin) > 0 And Len(MyPass) > 0
Set IE = CreateObject("InternetExplorer.application")
IE.Visible = True
IE.Navigate "http://www.youtube.com/login?next=/index"
'Loop until ie page is fully loaded
Do Until IE.readyState = 4 '4=READYSTATE_COMPLETE
DoEvents
Loop
With IE.Document.Forms("signupForm")
.Item("username").Value = MyLogin
.Item("password").Value = MyPass
.Submit
End With
Set IE = Nothing
End Sub[/vba]
if you can please help me auto login to this page, thank you.
Last edited by gsouza; 08-25-2007 at 08:26 AM.
-
Never mind, I figured it out.
-
Can you post your solution for the benefit of others?
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules