Sorry about not being able to clearly articulate my
problem, but if you open the URL in IE6 you get a minimum
of 3 lines of quotes and more if you have put the info in
beforehand. BUT, when you open the same address in Excel
AS A SPREADSHEET, there is a clear difference in that
Excel XP only brings in one quote instead of the multiple
quotes - which is very different to how it looks in IE6,
and that is my problem. The same command in Excel 2000
brought the page in as an Excel spreadsheet exactly the
same as it displayed in IE6 - with all the quotes.
I have tried the multi address but it doesn't provide the
info that I need.
I guess the question is - Why does Excel XP change the
webpage when it imports it into the spreadsheet and is
there any other command to try to bring the page in
another way?
Cheers
Rod
-----Original Message-----
I don't see how because the site must have the symbols
to show. Did you see
the second url I provided with the symbols.
I can custom design something if you want to send your
wb to my private
email below.

--
Don Guillett
SalesAid Software
Granite Shoals, TX

"Rod" wrote in message
...
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/defaul
t.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


.



.



.