Thread
:
opening webpage in excel
View Single Post
#
3
Posted to microsoft.public.excel.programming
Don Guillett[_4_]
external usenet poster
Posts: 2,337
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
.
Reply With Quote
Don Guillett[_4_]
View Public Profile
Find all posts by Don Guillett[_4_]