External Data using a macro

[Anthony Warburton]

Is there a way to create a macro 'button' to collect
refreshable data from an internet site that is password
protected.Then paste this info into an excel worksheet.


Example :-

Worksheet 1

Account Balance A :

Account Balance B :

So, the macro will goto a site ,lets say
https://online.lloydstsb.co.uk/customer.ibc where it will
automatically log on given the correct passwords, collect
the current balance then export that data to my worksheet,
under the 'Account Balance A' heading.

Thanks for helping

Anthony