Website login popup comes up blank in VBA "edit web query" - webpage login problem

Hello All,

I have a problem with a small part of a quite large programme that allows me to work out investment nett worth (ISAs, shares, property etc) at the push of a button.

My VBA was working previously under Excel 2013 and Windows 8. I believe it has worked under Windows 10 but there have been substantial updates to Windows 10 recently(?). Also it is possible that the website itself has been changed/updated.

I am trying to import a chunk of a financial webpage (as an Excel table) from http://www.morningstar.co.uk/uk/ using VBA in Excel 2016 (and windows 10 64bit). I have set up a "Data Connection" to the website that is simply refreshed using code:

Sheets("TIM").Select
    Cells.Select
    Selection.ClearContents
    ActiveWorkbook.RefreshAll

I have used the Data/Connections/Properties/Definition/Edit Query to try to (re)login. [This method has worked for me on other financial website]. If I press the Login button (on the top right hand corner of the website under this query), a popup opens. This popup when opened in a normal browser eg Chrome, allows entry of the Username and Password (UN/PW). However in the edit query mode this popup is blank ie I cannot enter the UN/PW. I don't know how this popup is called: I could guess at javascript....but that would only be a guess.

Without being able to enter UN/PW, I cannot get to the data I want to import into my VBA.

I have tried logging in (outside of VBA) to the website using Chrome, Internet Explorer 11 (which data connection uses?) and Opera but the login UN/PW doesn't seem to "stick" when I go back to VBA. My VBA crashes. It continues to run past the login phase (probably because I have no error checking at this stage). The VBA then fails as I try to extract specific data (since the webpage I try to import doesn't include the financial data....because I'm not logged in!)

I picked Morningstar since it is the only site I have been able to locate recently that includes (nearly) all the investments that I want to monitor. Over the years I have used various financial websites and I have to say I am getting a bit fed up with having to change website and re-code my (quite large) VBA.

Can anyone suggest how to solve this please?
Thank You (in advance)