How can I extract specific data from websites into an Excel spreadsheet?
For example, consider the website http://www.asx.com.au/asx/research/company.do#!/BHP
I would like to:
1) Copy to a cell in a spreadsheet (or otherwise extract) the link under the heading "Contact Details" on that webpage (i.e. http://www.bhpbilliton.com/
2) Copy to a cell in a spreadsheet (or otherwise extract) the link for the file titled "Annual Report 2014" (displayed under the heading "BHP announcements" after "Financial & Periodic Reports" is selected from the dropdown menu) and then save the linked file to a specified location on my computer.
What is the easiest way to do this using VBA?