Hi Don,
I am wanting to open this as an Excel spreadsheet so that
I can utilyze the data in my main spreadsheet. When you
open the URL in Explorer it shows a minimum of 3 quotes,
and if you add more, then it will show your entire list.
I used to just use the command in Excel 2000;
Workbooks.Open Filename:= _
"http://bigcharts.marke****ch.com/quotes/default.a
sp"
and it would open the URL in Excel with the multiple
quotes running down the page.
Now when I run the same command in Excel XP only one line
of information appears instead of multiple lines. I hope
that this makes sense.
Rod
-----Original Message-----
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/quotes/multi.asp?
view=q&msymb=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
.
.