anyone know how to embed a website data into excel?

maxims wrote:whoever able to do it..i will reward them with something very useful

. wrote:

maxims wrote:whoever able to do it..i will reward them with something very useful

you give me one soft kiss and a hug, I will tell you abt it [You must be registered and logged in to see this image.]

maxims wrote:

. wrote:

maxims wrote:whoever able to do it..i will reward them with something very useful

you give me one soft kiss and a hug, I will tell you abt it [You must be registered and logged in to see this image.]

i will give u my excel calculation[You must be registered and logged in to see this image.]

maxims wrote:

. wrote:

maxims wrote:whoever able to do it..i will reward them with something very useful

you give me one soft kiss and a hug, I will tell you abt it [You must be registered and logged in to see this image.]

i will give u my excel calculation[You must be registered and logged in to see this image.]

ejam77 wrote:

maxims wrote:

. wrote:

maxims wrote:whoever able to do it..i will reward them with something very useful

you give me one soft kiss and a hug, I will tell you abt it [You must be registered and logged in to see this image.]

i will give u my excel calculation[You must be registered and logged in to see this image.]

wwwaaaaahhhhhhh......u guys....don't let me behind aaaaa.....[You must be registered and logged in to see this image.]

phoenix wrote:[You must be registered and logged in to see this link.]

maxims wrote:i want that excel can retrieve web data such as hsi index...so that i don need to key in everytime hsi change ma...

. wrote:

phoenix wrote:[You must be registered and logged in to see this link.]

congratz phoenix cai, sifu gonna give u a french kiss and a hug [You must be registered and logged in to see this image.]

xettie wrote:excel can fetch data from yahoo finance. but it's delayed. lemme dig out my old excel...

. wrote:get external data (static) to excel can be easily done but getting live quotes like the indeces, I think no way can do it.

if you are able create such apps, then you will be a millionnaire in no time.

maxims wrote:

. wrote:get external data (static) to excel can be easily done but getting live quotes like the indeces, I think no way can do it.

if you are able create such apps, then you will be a millionnaire in no time.

i do already..i just want to improve my excel refresh timing to 5 seconds..not one minutes

. wrote:

maxims wrote:

. wrote:get external data (static) to excel can be easily done but getting live quotes like the indeces, I think no way can do it.

if you are able create such apps, then you will be a millionnaire in no time.

i do already..i just want to improve my excel refresh timing to 5 seconds..not one minutes

sifu chong ming, + 1 rep

Code:



Sub fetchData()

If ActiveSheet.Range("S9").Value = "1" Then
    Application.OnTime Now() + TimeValue("00:00:05"), "fetchData"
End If

...get info...


End Sub