Dear 'niner'
Microsoft moved it's financial information site to
http://moneycentral.msn.com/
there is no apparant link to the feature in Excel 2000. Excel 2002, 2003
have a microsoft add-in allowing them to do what you're trying to do. The
download is free
http://www.microsoft.com/downloads/d...displaylang=EN
Unfortunatley this means that I'm asking you to spend money on an upgrade to
your current version of Office. This is probably not too much of a shock for
you although you may not be willing to commit to it yet. Since the add-in is
available for office 2002 or later versions you might want to see about
getting a 'used' version of 2002. This is often a more cost effective way to
buy software.
GOOD LUCK whichever way you go!
"niner" wrote:
Excel 2000 has a "standard" query for stocks that contains the following
URL"http://investor.msn.com/external/excel/quotes.asp. The full query is
"http://investor.msn.com/external/excel/quotes.asp?SYMBOL=["QUOTE0","Enter
stock, fund or other MS Investor symbols separated by commas."]" When the
query is run the url is not found. Presently using version 9.06926 SP-3