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....
Bookmarks