Set objCollection = IE.Document.getElementsByTagName("input")
i = 0
While i < objCollection.Length
If objCollection(i).Name = "username" Then
objCollection(i).Value = "USERNAME" 'fill in username here between the ""
End If
Application.Wait (Now + TimeValue("0:00:01"))
If objCollection(i).Name = "password" Then
objCollection(i).Value = "PASSWORD" 'fill in password here between the ""
Set objElement = objCollection(i)
End If
i = i + 1
Wend
Application.Wait (Now + TimeValue("0:00:01"))
IE.Document.all("btnSubmit").Click
This is what I have but no idea how to do the following two:
I need a selection from a dropdown instead of the username
For a second login I need this for a second screen with only a password field. Deleting doesn't work.
Bookmarks