Is it possible for a macro to log into a website

[Shanakp]

Is it possible to set up a macro which will prompt the user to key in the user name and password and then the macro should use this information to log into a website with the username and password.

The web site link is https://cognizant.service-now.com/navpage.do

Some Info: If I go to Excel Menu "Data" and then click on "From Web" and then login to the website after which I can import a table, after one time password entry i can use data refresh to continuously grab the information. But even if I login using IE, if the session is expired on the excel window where I can fetch the data, the excel explorer still asks me to key in the password

Any help on this would be much appreciated.

[ajryan88]

Hi,

Are you familiar with creating userforms? If so, this is how you can create a prompt for a username and password. If not, let me know and I'll dummy up an example for you to have a look at.

As for the logging into a website with this information, I have absolutely no experience, but a quick Google search will definitely point you in the right direction (I found a heap of useful links but it wouldn't let me paste ALL of them here, so I didn't bother pasting any sorry)

Hope this helps

[Shanakp]

Thanks ajryan88,

I am not aware...i ll google n see if this helps me...thanks you :-)

[Shanakp]

I just had a look at it. Its too big. If you are anyone is an expert in this, please check if you can help me create one so that I can cross this last milestone

[ajryan88]

OK no problems, I will create a userform for you in the morning as a I have turned my computer off for tonight and am reading this from my phone.

[Shanakp]

That would be Awesome...This has kept be sleepless for sometime...Thanks

[ajryan88]

Hi,

Here is a userform that asks you to enter your username and password, and then stores those values in a variable so that you may use them later for logging into your website.

For logging into a website using VBA, try one of these links:
1. http://nhsexcel.com/how-to-use-excel...-to-a-website/
2. http://www.mrexcel.com/forum/excel-q...d-website.htmlHope this helps

[Shanakp]

lemme check...was away on vacation

[JasperD]

Whats the final result you want?
The webpage open and logged in - or do you want to pull data from that page?

[Shanakp]

The webpage open and logged in.

Here is some observations. Even if I am logged in to this site from internet explorer, unless I go to the browser that comes up after going to Data>From web and then log in to the site, till then the connection will not work. Once I login, I can fetch data from webpage till the session gets expired. Once expired , I would have to do the repeat this again

[JasperD]

If you use "data -> from web" you will still want to get (part) of the webpage downloaded, right?
Is this always the same data or do you really browse around there and pick the elements / tables as you go?
The reason why I ask this is because in excel you can get data pretty from web in several different ways

1) use "data -> from web", which opens the webpage in the excel browser and then you download (part) of it. The *only* advantage this has is that you can "cherry pick" the data you want every time; but the process is excruciatingly slow and you cannot store login / pass indeed

2) use an internet explorer object - the webpage opens in internet explorer ; you CAN store the login/pass this way and get data based on elements as well, but you'll have to pre-set which elements you want. This is slightly quicker, since IE is usually slightly quicker than the Excel browser

3) use an MSXML2.XMLHTTP object - with this method you don't open the webpage at all, but get the website response as a string in VBA and then parse / use that. This is the quickest and cleanest method and you CAN store username/pass with it. However, the response you get will still need to be parsed / sifted and you cannot get for example pictures this way, just plain old data.

There are more different ways, but these are the ways I have some experience with - I tried them all (in that order) and nowadays stick to method 3.

However, for me to give you _any_ real advice on how to go about this, it's important to know what you finally want to do with the website and excel in the end.

[Shanakp]

Its always the same data.

If i cant store the login data using 'data from web' option then i think i ll check how to do this using step 3

What i do is i go to the site, there is a table report there which i can copy or download.