'Below program will get stock/finance information in xml format from google finance.
'You can give the stocks from NSE and BSE as well.
'Specify the url to connect to
URL = "http://www.google.com/ig/api?stock=rcom"
Set objHTTP = CreateObject("MSXML2.XMLHTTP")
Call objHTTP.Open("GET", URL, False)
objHTTP.Send
'The response comes in the form of xml stream.
MsgBox (objHTTP.ResponseText)
What do you think on above excel macro topic? Please provide your input, comments, questions on excel macro. I will try to reply as soon as possible. I value your opinion on Excel Macros.
No comments:
Post a Comment