View Single Post
  #5   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 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/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


.



.