Automatic Login in site using vba

[Nelson78]

Hello everybody.

I need a help for login in one site.

My matter is that, in a different way respect my previous experiences, I cannot univocally identify the login and password fields.

For example, below you can see the framework of the login field, analysed seven times.


input id="lQ8g5" class="atbox" type="text" maxlength="22" value=""

input id="kR9g5" class="atbox" type="text" maxlength="22" value=""

input id="jSAg5" class="atbox" type="text" maxlength="22" value=""

input id="iTBg5" class="atbox" type="text" maxlength="22" value=""

input id="hA3g5" class="atbox" type="text" maxlength="22" value=""

input id="n30g5" class="atbox" type="text" maxlength="22" value=""

input id="yVAg5" class="atbox" type="text" maxlength="22" value=""


I'd like some suggestions, thank's.

 

[John_w]

Here's one way. If the login field is the first input element:

    IE.document.getElementsByTagName("INPUT")(0).Value = "your login id"

If it's the second input element change the (0) to (1), etc.

 

[Nelson78]

Ok for login and password, thank you.

IE.document.getElementsByTagName("INPUT")(0).Value = "your login id"
IE.document.getElementsByTagName("INPUT")(1).Value = "your password"

Now I'm struggling with the button, but unsuccesfully.
It's the only button in the page.


Above two exemples:

button id="z472n" class="button5" type="button">Enter</button>

button id="z425p" class="button5" type="button">Enter</button>


My attempt (error 438):

IE.document.getElementsByTagName("button")(0).click

 

[John_w]

What is error 438? Has the page completely loaded? Try it without the .Click, i.e. set it to an object variable to make sure the element exists before calling the Click method.

 

[Nelson78]

It was something about the pointer position, but I don't understood exactly what.
Anyway, in the following way it works.

IE.document.getElementsByTagName("INPUT")(0).Value = myId
SendKeys "{Tab}", True
IE.document.getElementsByTagName("INPUT")(1).Value = myCode
SendKeys "{Tab}", True
IE.document.getElementsByTagName("button")(0).Click

Have you got idea what could it be?

 

[Nelson78]

Some more details:
1 - the error 438 was linked to other steps, I solved it;
2 - without the SendKeys "{Tab}", True, the macro types correctly login and password, but the authentication fails with the following message: "please fill out all required fields", as login or password were not typed.