Thought you might like this

[Ron Scott]

Hi John,
Came across this in the News Groups, thought you might like it

Ron




How do you embed a NYSE Symbol (eg KO) in a worksheet and have it bring up a
current price when the worksheet opens up.

Thanks,

Craig
############################################################################
###
Create a hyperlink that points to your preferred stock quote provider's page
for that stock.

For example, for KO on NYSE, I'd go to MSN.com (or your preferred quote
provider) and get the stock's quote. Once I get the quote, I'd copy the web
address for the symbol's quote page (which in this case is
http://moneycentral.msn.com/scripts/webquote.dll?iPage=qd&Symbol=KO). After
copying the address, I'd go to Excel and type "KO (NYSE)" in a cell, then
right click it and select "Hyperlink." At the bottom of the "Edit
Hyperlink" window I'd paste in the web address. Now when you click on the
hyperlink, it will take you to the updated quote page.
############################################################################
Hi, J Craig--
Just realized you want the quote to pull INTO the worksheet. In Excel '02,
create a New Web Query (Data, Import External Data, New Web Query), type
your quote page's web address and click Go. Once you've pulle dup the stock
quote, click on the yellow arrow next to the table you want to import (where
the quote itself resides). Then write a macro that refreshes your data on
WorkbookOpen:

Private Sub Workbook_Open()
ActiveWorkbook.RefreshAll
End Sub