Display web chart in excel

[Snoopdoggywuf]

I am trying to create a financial spread sheet and link a chart from ADVFN so
it shows up live in my spreadsheet. Havent got a clue how to make this work,
any ideas would be appreciated.

Rgds
Mike

 

[jeff]

Hi, Mike,

I may not be understanding what you're after...
(and I don't know what ADVFN is) but,

have you tried inserting a hyperlink from the menu?
Select which cell you want the link to show, then
Insert->Hyperlink... and complete the information
(link address, name, screen tip, etc)

Or are you looking for something more??

jeff

 

[R.VENKATARAMAN]

JEFF apologise for intercepting.
the chart in webpage is a java appelet. I want to download the chart as an
excel chart so that I can manipulate.
If I use hyperlink in an Excel cell it only takes me to the java chart.

If I use "get exernal data" natuarlly i get some messed up data as follows
++++++++++++++++++++++
Online Stock Chart

Symbol : Search
Index Charts Equities Charts F&O Charts RDM Charts

Close Window
++++++++++++++++++++++++
even though the url conatins the symbol also
the actual url is(both lines)
http://nseindia.com/marketinfo/charting/OnlineStockChart.jsp?symbol=ALFALAVA
L&charttype=ONLINE_STOCK&series=EQ&mkttype=N

In the query window I have checked <entire page> and formtting as rich
text format

Probably only data can be downloaded into excel by this type of query
and not java based charts.

Mine excel 2000

any suggestions.

I found more or less a similar query by <Lee> on the subject "controlling
java appalet" in Microsofst. excel programming newsgroup which is quoted
below for easy reference to you

quote
I have written a macro below that opens up an instance of internet
explorer, logins in to a site with a username and password, navigates
to the appropriate part of the site and saves a) some text from the
site and b) some of the html from the site using the innerHTML and
innerTEXT properties

I am now stuck with the last part. I can navigate to the correct area
of the site. This brings me to a java applet which shows a bar chart
which changes as you drag a slider (at different ages) up and down. I
need to take screen shots of the graph at various different ages but I
don't know how (or if its possible) to move the slider from the applet
using VBA. Can anyone help please?
unquote

thanks.