getting external data

[Trebor777]

Hi. I want to link to a website ..... https://apps.virginmoney.com/fundpri...wFundPrices.do and read data from it into a sheet in my workbook. It is a 2-D table.

I think I need to use data/connections, but which of the options do I use?

I'd be happy to link the web into a new sheet in the workbook.

Can someone point out the route please & save me hours of experiment ?

Many thanks as always.

I have excel 2007 KK

[CK76]

You can use Web Query. See link for details.
https://support.office.com/en-us/art...4-7ee5f1b1cfba

I prefer using VBA for web scraping. Below code will output table values to Sheet1 (Change it as needed).

Please Login or Register  to view this content.

[Trebor777]

Thanks but I really want to avoid macros which I know nothing about. K

[CK76]

Then follow instruction in first link.

Or simply go to "Get External Data" -> "From Web"

Copy and paste in address. Hit "Yes"/"OK" until you see the page. Select the table and import.

[Trebor777]

OK this has worked well, easier than I dared hope. Many thanks. Does the page update automatically? KK

[CK76]

Does the page update automatically? KK

You are welcome. And yes. When you bring it in you can set properties to refresh every x minutes. Or when opening the file etc.
You can also edit it in connection properties.