Web Development

Ask something
Question Locked

Excel Web Queries and Password Protected Websites

0 helpful
3 replies

by dewale4244-web

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I need to pull data from several password protected websites.
These are ASP sites such as;
https://cld.countrywide.com/login/home.asp?
I want the macro to auto login and direct it to the pages behind. any ideas would be helpful

3 replies

by croasmunj

I have found a way to kind of get the job done using the sendkeys command. I just have a macro that pulls up Internet
Explorer, goes to the specified webpage, and then logs in (using sendkeys). I know that this isn't the best way to do it and sometimes it doesn't work perfectly but it seems like the best way that I have
found. If you do happen to find anything out I would love to know!

by sreemanoj

Could you pls. let me know macro using to pull the IE as well as how you are using the send keys.

This discussion is closed to new replies.