View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jef Gorbach[_2_] Jef Gorbach[_2_] is offline
external usenet poster
 
Posts: 65
Default download info from a web site to Excel

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.