Excel
In our last session we found that Excel could extract information like tables from a website.
Could we manipulate Excel to download a website (like the FT)s main headlines for the day and hyperlinks to those articles?
RE: Excel
Hi Mark
You can connect Excel to a website, but you will not get full "formatting".
On the Data tab click on Get external data connections from Web
When the box pops up, use the web address you require.
Click on the horizontal arrows dotted around the website to select different parts to download.
On the top right is an options tab, click on it and choose Formatting - Full HTML then OK
Click on the import button at the bottom of the box, choose a cell or Sheet as the download location and allow time for it to load
You can refresh this connection by clicking on the Refresh all button or pressing CTRL ALT F5
Let me know how that works for you
Kind regards
Richard Bailey
Microsoft Certified Trainer
Best STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
