How to add a web data on sheet using VBA..

[amruta_shah15]

Dear Friends,

When I write a symbol name in "A4 to A100" I want a LTP in "B4 to B100" and Volume"c4 to c100". I want to set this using VBA. as I want to make a some more changes in this sheet.. the data should be taken from following link as I am working on intranet and this site is allow in my intranet network..

http://www.moneycontrol.com/terminal/?index=9

Example:- when I write a name "Acc" in "A4" , LTP should be in "b4" and Volume in "c4"...
when I write a name "BHEL" in "A5" LTP of BHEL should be in "B5" abd Volume of BHEL in "C5"...

it is a Live refresh on second to second .. so same should be refresh in the sheet also...


please help me in this..

thank You in advance....