Web Scraping: From Excel to Web back to Excel

[GiraffeValue]

Hi Everyone, I'm a total newbie.

Can anyone guides me to the right tutorial. what I need to do is as follow:

1. Copy a URL from excel

2. Go to the web with that URL.

3. Highlight the data and copy it.

4. Paste to Excel.

It sounds easy, but would be hard for starter to write a script for that?

I'm now watching some of the beginner videos on YouTube. Please let me know what should I foucs on.

Many thanks!

[water]

Welcome to AutoIt and the forum!

All Excel related stuff can be found in the Excel UDF that comes with AutoIt.

All web related stuff depends on the browser you use. AutoIt comes with an UDF for Internet Explorer. For FF and Chrome you'll find UDFs on the forum.

[ViciousXUSMC]

I think Waters Excel UDF and the Autoit IE UDF will be your best friends for this.  Depending on what you want to do you can even have it run in the background silently and parse the source code of the page rather than highlight/copy/paste.

Its not exactly easy, but not exactly hard.  If you get a starting point you can get help here on the forum.

Im still not very good with the word/excel udfs but Water is the expert and always helped when I needed it. 

Edited September 22, 2015 by ViciousXUSMC

[water]

Thanks for the kind words
I will do my very best!

[GiraffeValue]

Hey ViciousXUSMC and Water

Thanks for the reply, I don't think I'm able to get the data through its source code, it seems that it shows under java script or something.

I have attached the link and pic for your reference:

http://www.sgx.com/wps/portal/sgxweb/home/company_disclosure/stockfacts?page=1&code=ADQU

Previous Open Price	0.65	Previous Day High/Low	0.655-0.645
Previous Day Volume	0.15 mm	Previous Close	0.645
Previous Close Date	22/Sep/2015	52 Week High/Low	0.925-0.595
5-Year Beta	-	Shares Outstanding	1,099.12 mm
Average 3-month Volume	1.78 mm	Normalized Diluted EPS	0.04
Total Market Cap	S$ 708.9 mm	Float	65.48%
6-month VWAP	SGD 0.707 as of22/Sep/2015

 

So my question is what function should I use for getting the Numbers copied?

[water]

I just had a quick look at it. Wouldn't it be easier to use one of their data services to access what you need?