On Jul 15, 10:00*am, mariaagustina wrote:
Hi!
I would like to learn how to use Visual Basic (which came with my
Excel 2007) to download information from a web site and insert the
data into a cell in Excel. For example, suppose I wanted to acces a
Yahoo Finance web page to get a stock price for a given ticket symbol
and put the stock price into a cell in Excel.
My idea is being able to update everyday when the stock market closes,
the cell with the price of the stock in Excel
thanks,
maria agustina
A quick google search found several examples with the first being a
step-by-step recording (with screen shots and resulting code) you
might consider studying:
http://gove.net/home/page21.html
My search:
http://www.google.com/search?sourcei...+yahoo+finance
for the rest.