Logging in a website with Macros

Hello, and again, let me first thank you for spending some time on this.

I'm trying to automate some webscraping on a website that requires a login, and was wondering how I would do so using Macros with a specific username password somewhere in the spreadsheet, lets say B2, and C2 respectively.

The website I'm trying to login is this; http://underground.chacha.com/account/

I think I have most of the scraping figured out; its just the log-in for now.

Any help would be appreciated!

Thank you.

Good morning pink

Originally Posted by pink

I'm trying to automate some webscraping on a website that requires a login, and was wondering how I would do so using Macros with a specific username password somewhere in the spreadsheet, lets say B2, and C2 respectively.

Let's forget about where the username and password are stored for now - sorting out that bit is simple. The tricky bit is logging onto the website. I will point you for now to a link in VBAExpress' knowledgebase by poster Oorang. This shows you how to log into Googlemail using VBA - but the principle will be the same for your application (but just so you know, the "ease of use" is set to hard!).

http://vbaexpress.com/kb/getarticle.php?kb_id=973

HTH

DominicB