View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Don Guillett[_4_] Don Guillett[_4_] is offline
external usenet poster
 
Posts: 2,337
Default opening webpage in excel

I'm not sure I understand your problem. When I just click on the url below
and goto this site it will accept only ONE symbol at a time. No matter which
xl or how you open would make no difference. Yahoo accepts multiple quotes.
Tell me EXACTLY what you want to do and I will try to help. Or, I can custom
design something.

Sub tryxl()
ActiveWorkbook.FollowHyperlink Address:= _
"http://bigcharts.marke****ch.com/quotes/default.asp"
End Sub

This url DOES allow multiple quotes.
http://bigcharts.marke****ch.com/quo...symb=msft+intc

Now if you want to use the quotes in xl, use a different method.

--
Don Guillett
SalesAid Software
Granite Shoals, TX

"Rod" wrote in message
...
Hi Don,

http://bigcharts.marke****ch.com/quotes/default.asp

You can add your own codes - I have supplied some samples
below. Just copy and paste into the "add symbol" field.
MSFT INTC AMZN
If I open the same page via excel XP it only displays the
1st line. If I open the same page in excel 2000, it opens
all lines OK

Thanks for your interest
Rod



-----Original Message-----
can you post the url

--
Don Guillett
SalesAid Software
Granite Shoals, TX

"Rod" wrote in message
...
Hello,

I used to be able to open a webpage in excel 2000, but

I
am having trouble with excel XP. The webpage has

several
lines of user defined data but when I open it up in

excel
XP, I only get the first line. I have rechecked the
address in IE6 and all the data comes up.
Are the any differences between excel 2000 and excel

2002
in regards to this?
Any ideas would be appreciated.

Thanks in advance
Rod



.