Hi,

I would like to make a vba to get the website information. May I know
what kind of script able to do that?

excel worksheet format:
column A: Stock Code (eg: HKG:0005)
column B: Now Price (eg: 89.30)
column C: other information (not important)
_______________________________________________
http://www.google.com/finance?q=HKG%3A0005

89.30
-0.10 (-0.11%)
Delayed: 12:29PM HKT
HKG data delayed by 15 mins - Disclaimer Range 88.95 - 89.90 52 week
33.00 - 98.25 Open 89.40 Vol. 6.04M Mkt cap 1.55T P/E 212.91 Div/
yield - EPS 0.42 Shares 17.34B Beta - Inst. own -

On Jan 4, 7:40*pm, Danny wrote:
Hi,

I would like to make a vba to get the website information. May I know
what kind of script able to do that?


Hi Danny, have a look at:

http://scriptorium.serve-it.nl/view.php?sid=40

It gives you the code for getting the text content of a webpage.

AP

NP, Danny. follow the steps he
http://www.mrexcel.com/tip103.shtml

Do what you need to do a couple times; get comfortable with it. Turn on the
macro recorder, go through the steps, turn off the macro recorder.

Finally, link the code to a command button:
http://www.mrexcel.com/tip068.shtml

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"AP" wrote:

On Jan 4, 7:40 pm, Danny wrote:
Hi,

I would like to make a vba to get the website information. May I know
what kind of script able to do that?


Hi Danny, have a look at:

http://scriptorium.serve-it.nl/view.php?sid=40

It gives you the code for getting the text content of a webpage.

AP
.

hi, thanks.

but it spent ~26sec to get information from 20pages website. seems too
slow.