Using VBA To Automate IE and input user name, password, and hit submit

[Slape]

I'm trying to use VBA to go to a website that requires a User Name, Password, and a Submit Button.

So far I can get everything to work besides the Submit part. The code runs without errors, but doesn't actually "hit" the submit button on the webpage.

For posting, I removed my actual user name and password and and used the generic "User Name" and "Password" highlighted in blue.

I highlighted another section in green that I took from a previous post hoping it would solve my problem. The link is: http://www.mrexcel.com/forum/showthread.php?t=317060&highlight=vba+internet+explorer+submit


Here is the code I am using:

Sub GoToWebSiteAndPlayAroundNew()

Dim appIE As Object ' InternetExplorer.Application
Dim URL As String


Set appIE = CreateObject("InternetExplorer.Application")
URL = "https://efolio.morgankeegan.com/escripts/defaultLogon.asp?errCode=2"


With appIE
.navigate URL
.Visible = True

Do While .busy: DoEvents: Loop
Do While .ReadyState <> 4: DoEvents: Loop

.document.getelementbyid("fUserName").Value = "UserName"
.document.getelementbyid("fPassword").Value = "Password"

End With


On Error Resume Next
x = 0
For Each mitem In IE.document.all
mitem.Value = "x"
x = x + 1
Next

x = 0
For Each mitem In IE.document.all
If x = "Submit" Then
mitem.Click
Exit For
End If

Next

End Sub

 

[pedie]

Hi Norie, I was referring to our [this] forum...
I cant make out which one is login submit button + same with facebook..
Username and Password gets inputed then stops because i dont know where to let vba click on submit...


Thanks again Norie!

links:
1. http://www.mrexcel.com/forum/index.php
2. http://www.facebook.com/

 

[Norie]

Pedie

If you look at the source code of either page you should be able to find what you need.

 

[pedie]

Norie, I did check it out but could not get it...

I found username = vb_login_username
and password = vb_login_password
but cant find submit button name...

??

Thanks again

 

[Norie]

pedie

Is there a specific URL you want to do this for?

You mentioned 'practice', but you can't really do that for this sort of thing.

Anyway for FaceBook the ids for the email and password are simply 'email' and 'pass'.

The login button id is uXXXXXX_X, where X is a digit.

I've not posted the actual digits because I think it might be randomly generated.

Not sure about that though.

 

[pedie]

Great! thanks Norie...
I still cant find for this forum...I mean the submit button, sorry

Pedie

 

[Norie]

Pedie

How are you checking the source code?

By the way, can't you 'practice' on another site?

Oh, almost forgot - the digits for the id for the login button on Facebook are random.

 

[pedie]

Pedie

How are you checking the source code?

By the way, can't you 'practice' on another site?

Oh, almost forgot - the digits for the id for the login button on Facebook are random.

Okay Norie, thanks for letting me know about that...
Here is another link i log on to everyday maybe I can automate this if you help me:https://login.yahoo.com/config/login_verify2?&.src=ym&rl=1


I view the source code my right clicking on the webpage and then click on "View Source" is that the same thing I need to follow?

I just dont know how to identify which letter or letter can mean that it is submit button....


Thanks again!


PS: Is there a way of identifying these things? for example what is what[clickable button, password text box etc?]

 

[Norie]

pedie

Please start a new thread for your own questions.

Posting in an existing thread can confuse people, and even put people off answering your question.

 

[pedie]

Okay Norie, thanks again...this a great learning...
Though i dont actually understand it completely I now know this can be done!

 

[MardiB16]

Hi Norie, I know that the above thread is quite old however, my need for answers is about to drive me batty! I have been searching for a way to automate date entry process from excel to webform. I can get the macro to navigate to the website "http://www.themightygiant.com/cm/index" but can't figure out the code to populate the 'popover' webform. not sure if you or anyone else can help but I'm running out of options. Can anyone help?

I'm Youtubed Out!!!