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:
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)