I am using Excel 2003 and trying to put together a worksheet with stock
prices, using smart tags. The stock prices all update (I'm using MSN Money
Stock Quotes), but not every stock symbol displays a smart tag. The smart
tags are helpful as they carry a link back to news and other info on the
stock.

How can I get ALL the stocks to show smart tags? Incidentally, the stocks
I'm talking about are well known stocks like GM, Proctor & Gamble & Ford.

Thanks in advance.

You can download the Excel 2003/2002 Add-in: MSN Money Stock Quotes:

http://tinyurl.com/dw948

This won't automatically create a smart tag for GM, for example. But
you can use the "Insert Stock Quotes" function on the newly installed
toolbar to create a quote for GM, which will drop that quote onto the
sheet where you specify. Then you can copy and paste the cell with
"GM" in it (now with a smart tag) to where ever else you might need it,
and the smart tag will go with it.


--
Excel_Geek


------------------------------------------------------------------------
Excel_Geek's Profile: http://www.excelforum.com/member.php...o&userid=26423
View this thread: http://www.excelforum.com/showthread...hreadid=400137

Hey good stuff! Thanks for that solution, it's not slick, but it works!

"Excel_Geek" wrote:


You can download the Excel 2003/2002 Add-in: MSN Money Stock Quotes:

http://tinyurl.com/dw948

This won't automatically create a smart tag for GM, for example. But
you can use the "Insert Stock Quotes" function on the newly installed
toolbar to create a quote for GM, which will drop that quote onto the
sheet where you specify. Then you can copy and paste the cell with
"GM" in it (now with a smart tag) to where ever else you might need it,
and the smart tag will go with it.


--
Excel_Geek


------------------------------------------------------------------------
Excel_Geek's Profile: http://www.excelforum.com/member.php...o&userid=26423
View this thread: http://www.excelforum.com/showthread...hreadid=400137