Logging in a website with Macros

[pink]

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.

[dominicb]

Good morning 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

[pink]

DominicB,

Thank you for your reply. I tried to decipher that info on the link you gave me... and yes, I know why the "ease of use" is set to hard. I ended up browsing the web to look for other methods.. and ended up using something like this:

Const PostUser As String = "handle="  'Change user name here
Const PostPassword As String = "&password="  'Change password here
MyPost = PostUser & Trim(Range("C4").Value) & PostPassword & Trim(Range("C5").Value)
p = Range("C6").Value
With ActiveSheet.QueryTables.Add(Connection:= _
    "URL;" & MyUrl, Destination:=Cells(1, 1))
    .PostText = MyPost

And it works. However, I don't know if its the BEST way to do it...

Thanks for your input!