Completing a webform with VBA

[Sc0tt1e]

I am attempting to work out how to complete a web form on www.Airbnb.com, specifically the "Log In" section using my email and password.

I know how to call the IE object for the website but am having trouble trying to select the Log in hyperlink so it can be completed. Can anyone advise how this can be done please as the webdesign doesn't conform with anything I am reading online

I think Set Allhyperlinks = IE.Document.GetElementsByTagName("A") is the bit to change but can't work out what to change it to.

Any advice would be appreciated.

Please Login or Register  to view this content.

[AB33]

This opens the log-in page, but it will not help you much.

Please Login or Register  to view this content.

[Sc0tt1e]

You're a star, that works
Now I see I don't need READYSTATE3 and the Call IE.Document.GetElementsById("(email)") & ("(password)") don't work and I'm guessing it's because I should be using a different element to ID but I have tried them all and it won't call.

Any ideas?

[AB33]

Tyr this one, but you might get an error on click as I am not sure if it works.
You need to change user name and password to actual log-in details

Please Login or Register  to view this content.

[Sc0tt1e]

It's missing the .value on signin_email without that the email address isn't entered.

Also if I run the code either the log in page isn't created or it is and the email address and password don't populate but if I step through the code it does, why is that????

Also error message runtime 462 populates on the user login button?

[AB33]

With the password and username you have, I managed to get these values in to the text boxes, but it did not log-in. Step over using F8, and before the code reaches the click line, you can check the site and see for yourself.

[Sc0tt1e]

As I said, if I step through the code it works, if I run it it doesn't.

The code for the email and password is run before the log in page is created as such there is no object for the email value to populate

[AB33]

It is probably the code is trying to populate the details before the page is fully loaded.
You can add a wait function and change the wait event.

While IE.readyState <> 4: DoEvents: Wend

Set doc = IE.document

Application.Wait (Now + TimeValue("0:00:05"))

[Sc0tt1e]

isn't that what the below bit of the code is doing?

Please Login or Register  to view this content.

When I change to your code it now says there is no object for the email value to populate?

[AB33]

I am confused what is working or not working. I can not test it, as I do not have the right to access the site.
If the code works using F8, but does not work when you run it, I can only assume that there has to be a time lag between the first session and the second.

Please Login or Register  to view this content.

[Sc0tt1e]

Correct, that was the problem

You suggested the wait code which I have added and which loads the page before the macro can run again but now I have added the wait it produces an error message where there wasn't one before (I have not signed up for this site yet I am testing to see if I can log in before doing so as this is just stage 1 of a multi stage macro)

The red line is where I get the error, I have added a screen print so you can see what I am seeing when the error occurs

Please Login or Register  to view this content.

[Sc0tt1e]

I'm not sure how this happened but the ID names for the email and password fields has changed (see code which now works up to the log in button which has now also changed (under a span tag??) and I do not know how to refer to this now. If anyone (AB33 if you're not too tired of this yet) can advise I would be greatly appreciative?

Please Login or Register  to view this content.

[AB33]

I do not know.
I have tried both of these, but the e-mail box does not seem to accept any of these.

Please Login or Register  to view this content.

[Sc0tt1e]

see my last post, these two fields are now working as I have changed the ("...") part of the code

Please Login or Register  to view this content.

It is the userbutton.click part of the code below that now does not work

Please Login or Register  to view this content.

[AB33]

No, I have got an error on

Please Login or Register  to view this content.

[Sc0tt1e]

I have included the document and all it's code so it can be run and it allows me to populate the fields email and password fields.

I did notice that the names seemed to changed (from email to email-login-email) after the assistance provided by you earlier in the day when you provided the id names.

[AB33]

Well, I am still getting error on the password line using the attached code, but if you manage to get in to the password and username, but click button is not working, you could try a "Submit" instead of click.
I have the feeling that you can not automate using IE. I think it is done on purpose not to allow auto completion.

[Sc0tt1e]

submit doesn't work, anyone any idea how I can get the submit button working?

[AB33]

I do not think the site accept automation. I even looked at alternative way of getting around the log-in details.