Excel VBA Introduction Part 47.4 - Logging in to a Website with Windows Security

By Andrew Gould

[AntrikshSharma]

Now you have again raised the Bar with this!

[femaledeer]

This is way above my head. I have no idea what you are trying to connect to that requires windows security.

[MinuteGaming]

I am so happy to see you make videos again!

[techconnectlearning]

Andrew much awaited video. Thank you for uploading this. Really you are rockstar.

[dominikba]

Hey Andrew, is there a way to combine "Logging in to a Website with Windows Security" with "downloading files form websites". First log in, then download the file automatically??

[janezklun]

Very interesting topic, Thank you Andrew, Cheers

[paspuggie]

Now you know my secret Andrew. This is what I mentioned to you in another thread 😉

[chandankumar-npez]

I have watched many of your videos and all are very good. I have one question. Is it possible to download Excel dump file from client website after doing logins into the website.

[DPaquette]

What version of IE are you using in this video. We only have 11.0 here at work and I am on Office 2013 Pro Plus. The New does not come up correctly.

[kunwarjeeMandal-vvoq]

Hi Andrew, when i tried to run macro getting error like "The remote Server machine does not exist or is unavailable.
Please help to resolve if possible.

[mmtenyakov]

Another issue im running into. ive tried different website as examples and when I run the macro. and I'm referring to the Sub LogintoWebPage() the simple code to navigate to the url that is in sheet one. well when I do that nothing happens, it acts as the code has ran but no internet explorer window opens up

[gameforfun__]

What's about default browser? XML one is not giving any visible output

[nakuladas]

How to login to website, having to enter captcha then extract data from clicking different links or different table in different links?

[gameforfun__]

As feedback n all other credentials are confidential, can you Please use some other credentials or commonly used webpages to make entire process visible n clear ?

[VernonGibson]

What if the website uses Active Directory and only falls back up the login prompt if AD login fails? I'm on vacation and cannot test this tonight now but I'm curious if there's anything special needed got AD pages.

[KhalilYasser]

Thank you very much. Waiting for the file so as to make use of the presented codes or just share the code without the file to keep your credentials secure and safe

[irdammauludi]

this tutorial was great, .
but i still didnt understand how it work, can it be use to grab information inside the website without having credentials intstead we can use our windows security credentials?

[rakeshkumar-iwnk]

I tried to open a application using Excel VBA. I need to enter user name and password for Windows Security Alert. I have used the same code but send keys are not working in the dilaog box

[rbloesser]

I would love to see a deeper dive into logging on with XMLHTTP. The simple use of USER and PASSWORD on the ".Get" line often does not work. I would like to see more about using APIs and reading a site to understand how to construct the request with headers, and what headers are used for, xml.getResponseHeader("Set-Cookie"), etc. Thanks for the great videos and great instruction. - R

[mmbcampus]

As IE is dismissed, so do you have any alternative tutorial to populate web page form?