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:

VB:

Please Login or Register  to view this content.

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)

I have not tried it my self since I do not have excel 2016. Power Query is a good tool to scape tables in to excel. Try it if you have excel 2016. I believe PQ is part of excel 2016, but it is add-in in 2010 and 2013.

Hi AB33,

Thanks for replying and trying to help.

I think that PQ (part of "Get & Transform" in 2016) is a sort of wizard for getting external data/new query.

My issue is with a blank login popup. I (hope I) have attached a couple of jpg showing what the login screen looks like in Chrome/IE/Opera and then what it looks like in the Excel VBA browser when I try to log in using Data/Connections/Properties/Definition/Edit Query.

Login Capture.JPG
Login Capture 2.JPG

Under Excel, the popup is completely blank and non-working (except a non-functioning "close" button).

Any ideas why it is blank?

So when you log in using name and password and click Login button you get a blank page. How are you entering the name and password. What method are you using? Is get or post method?.

On the edit web query, you should be able to include the log in details with the URL and should connect auto with out seeing anything.