Extracting of data from a website using VBA or XML or data source connection

Hi,

I have a need to import the data from a website (login required), to be inside a table. This will mean that I just have to enter the unique ID of a person in Cell A2, and Cell B2 will automatically retrieve the person's Name, C2 as the person's birthday, etc.

I have tried using data source connection, but I am not good at using data source, and could not get Excel to import the data that I need (somehow the data is in another frame and could not be imported).

Could someone help me out? Many thanks.

Hi, anyone could help me out with this?