View Single Post
  #9   Report Post  
David McRitchie
 
Posts: n/a
Default

Hi Doug,
When you post something new it should *not* have any indication in front
as that indicates previous material, the deeper (, ) the earlier within the thread,
you could also clip out less relevant parts, especially if you are going to
bottom post, because most people will have just read the previous posts.

You will have to look at your macro code to see what you have to change.
It is not going to be exactly the same change for everybody, but where
two symbols are entered the format of the output differs than if only one
symbol were supplied.

Based on Jason Welles information

Different Ways of Using Web Queries in Microsoft Office Excel 2003, MSDN
http://msdn.microsoft.com/library/en...asp?frame=true

watch out for old links within query:
Old: http://investor.msn.com/external/exc...YMBOL=MSFT,IBM
New: http://moneycentral.msn.com/investor...YMBOL=MSFT,IBM

Old: http://quote.money.cnn.com/quote/quote?symbols=msft
New: http://money.cnn.com/quote/quote.htm...ymb=MSFT%20IBM (not sure)

You will have to look to see where the macro is that you are running and look for
code that invokes bringing up and HTML page but as a query. If you look at
the several MSDN examples in teh first link you will get an idea of what you are looking
for based on the example below that link.

-
HTH, (see my stocks.htm page)
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"DAL1066" wrote in message news:7E10D7F8-A7A9-44A2-8D7E-
Thanks...how do I enter this new query or modify the old one...please help
Doug