I have written an EXCEL VBA web query to get data from Yahoo finance. ( I used the macro recorder).
I now need to get data from Morningstar. I have an account, user ID and password. If I log into Morningstar prior to running an Excel web import query, it allows me to select various tables by clicking on yellow tags. However the site appears to still be not logged into. Clicking on import does not import data.

Question 1. How can I query a site that requires a log in (in general)?

Question 2. How can I query Morningstar (in particular)?