HTML scraping using VBA

How can I using VBA do HTML scraping?

A site which I have to use to update some data on a spreadsheet does not offer any web services. I have to copy data from the spreadsheet one cell at a time, paste into the search field and look at the results and decide what kind of modification is needed for that piece of data.

If VBA can do HTML scraping here is what I thought I could do.
For each of the data in the cell, I need to go to a search field on a website, manually enter the values and hit search. Then the browser generates a url like "http://www.mysite.com/search?hl=en&q=SNX018923" and returns the result as an HTML page. How can I use vba so that I can automate this process of generating the url and load the returned html text into a variable. Then I can use the script to search for a pattern of text and do something to the active cell from where the data was taken.

*nix has a curl command. What is the equivalent of curl in VBA? How do I use it to get the result I am trying to acheive?

Got the solution.
So the moderater may delete this post.

Record a macro while running a webquery on the test link at the website and I have a set of vba code to start with.

Am just amazed by what I could do with excel in such a short time with what my *nix colleagues used to show off with perl, grep, awk and such unix commands...

can someone provide the code for this as mentioned above?