website login through vba

**abousetta** · 03-03-2012, 09:13 PM

Hi,

Need some help with someoone with knowledge of website login via Excel. Below is the html code for section of the login page.

HTML Code:

I used to be able to login to a similar website using:

Please Login or Register  to view this content.

where the username and pasword would go, but this is not working with this site even thought they use the same proxy system. I think it have to do with the design of the webpage here Form --> Table --> TBody --> TD --> Input instead of Form -->Input in the other website.

Could someone show me what I am missing?

abousetta

**AlvaroSiza** · 03-04-2012, 03:11 AM

Hi Ab,

When I 'view source' of the url contained within the HTML you offered, I get different name and password values to be queried. I'm thinking it might be as easy as changing the

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

and the

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

I was successful in passing a username, password, and clicking the submit button with the following. Hope this helps, -as-

Please Login or Register  to view this content.

**abousetta** · 03-04-2012, 08:06 AM

Hi @AlvaroSiza,

Thanks for taking the time to look into this for me. Unfortunately it didn't work as I do not login to the website directly but through a proxy server. That's where the code I posted came from. I have attached a workbook with your code and the correct URL for the proxy. It gives me an error (Object required) at this line:

Please Login or Register  to view this content.

Any thoughts?

abousetta

**AlvaroSiza** · 03-04-2012, 02:22 PM

Ab,

Took a little work, but I was successful with the following. Let me know how it goes on your end. <HTML Manipulation can be tricky>

Please Login or Register  to view this content.

**snb** · 03-04-2012, 04:10 PM

As far as I can see/check this will do the same trick:

Please Login or Register  to view this content.

**AlvaroSiza** · 03-04-2012, 07:01 PM

SNB,

I tried your offering and it fails at the first instance of .getElementByID. I had tried this, along with every other 'simpler' way of going about the problem prior to the ultimate collection loop.

Ab,

As I just stated to SNB, I would have preferred to take a simpler route in solving this one, but in this instance, I was unable to be successful without the loop. I would not be qualified to point out the pluses/minuses associated with each method as a general best practice. As you rightfully assumed, this way 'just worked'.

**abousetta** · 03-04-2012, 07:06 PM

Hi snb,

Unfortunately your solution doesn't work because the username and password are to enter a proxy not the actual website. I am trying to fill the objects on "http://proxycheck.lib.umanitoba.ca/libraries/online/proxy.php?http://gateway.ovid.com/autologin.html" but your code errors at these two line:

Please Login or Register  to view this content.

with an error that an object is required.

abousetta

**AlvaroSiza** · 03-04-2012, 07:18 PM

I suppose you could borrow the With End With construct from SNB for efficiency and simplification. It would look like this:

Please Login or Register  to view this content.

**abousetta** · 03-04-2012, 09:32 PM

Thanks everyone. I did some playing around and made one observation. The webpage is using 4 forms. The last form is the one that contains the username and password input fields. Therefore I made a slight modification to the last code above to appear as follows:

Please Login or Register  to view this content.

That way it doesn't have to loop through all the different objects but limits them to the ones in the last form.

Now having said that, I still can't use the simple syntax to get it to work

Here are the objects by TagName("Input") located in Forms(3) but I still can't seem to make it work

Please Login or Register  to view this content.

Anyways, I just wanted to post this in case anyone is interested. For me, the Collection method works and that's the important thing.

Thanks again evveryone.

abousetta