Get website information
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 - |
Get website information
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 |
Get website information
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 . |
Get website information
hi, thanks.
but it spent ~26sec to get information from 20pages website. seems too slow. |
All times are GMT +1. The time now is 07:57 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com