Web Development



Excel Web Queries and Password Protected Websites

By dewale4244-web ·
I need to pull data from several password protected websites.
These are ASP sites such as;
I want the macro to auto login and direct it to the pages behind. any ideas would be helpful

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Collapse -

Try this

by croasmunj In reply to Excel Web Queries and Pas ...

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!

Collapse -

send keys

by sreemanoj In reply to Try this

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

Related Discussions

Related Forums