Extract data from web

[Khushi Vijay Kotian]

HI,

I would like to extract data from below given site through web query. It
needs to input date of query. HOw this can be possible through VBA?. I
tried to record macro and run it but not successful.

The web address is;
http://www.moneycontrol.com/stocks/marketstats/blockdeals/index.php

Thank you for your hlp.

 

[Khushi Vijay Kotian]

Hi Joel,

Genius.... what a code!! I could not understand head or tail of codes....
from where it takes data from and stores in a variable and writes back into
excel.... superb way of coding. Thanks for your prompt reply.

The codes given by you gives current day's report but if i want to have
previous days data by entering my preferred date and then extract the data
similar to previous one, into excel sheet. HOw can i do it.

Thanks once again.