LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 89
Default username and password controls


I was working on this with Joel earlier.
I have the following code which is barfing on ipf.Value = username
When I look at the html code for this page the username tag is name and the
password tag is id. The code is barfing when I try to set the value for the
username tag. any help below is appreciated.

Public Sub Login()

'Dim ipf As Object
Dim username As String
Dim pass As String
username = "vvv"
pass = "vvv"

Set ie = CreateObject("InternetExplorer.Application")
With ie
.Visible = True
.Navigate "www.elliottwave.com/"
Do While ie.ReadyState < 4 And ie.Busy = True
DoEvents
Loop
Set Form = ie.Document.getElementsByTagname("Form")
Set GoButton = Form(0).onsubmit

Set ipf = ie.Document.getElementByID("name")
ipf.Value = username
Set ipf = ie.Document.getElementByID("id")
ipf.Value = pass
Set ipf = ie.Document.all.Item("global_login_loginbutton")
Do Until .ReadyState = 4
DoEvents
Loop
ipf.submit

End With

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
Username and password login. Moh Excel Programming 10 December 21st 07 03:36 PM
Password/UserName Gordon[_15_] Excel Programming 1 January 19th 07 09:04 AM
Web Query: Username and Password. Sharad Naik Excel Programming 0 December 16th 04 09:43 AM
username & password check Jack Excel Programming 5 October 8th 04 03:20 PM
creating a username and password box kil Excel Programming 1 May 20th 04 08:20 AM


All times are GMT +1. The time now is 12:27 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"