+ Reply to Thread
Results 1 to 5 of 5

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

  1. #1
    Registered User
    Join Date
    10-11-2012
    Location
    Essex, England
    MS-Off Ver
    Excel 2016
    Posts
    5

    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)

  2. #2
    Forum Guru
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,445

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

    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.

  3. #3
    Registered User
    Join Date
    10-11-2012
    Location
    Essex, England
    MS-Off Ver
    Excel 2016
    Posts
    5

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

    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?

  4. #4
    Forum Guru
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,445

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

    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?.

  5. #5
    Forum Guru
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,445

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

    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.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Auto Login to Edit Web Query dialog
    By vrammos@yahoo.com in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-03-2021, 02:34 PM
  2. VBA code to login a webpage - Submit problem
    By edneco in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 09-13-2015, 01:37 PM
  3. VBA to Edit Query and Login
    By memamu in forum Excel General
    Replies: 1
    Last Post: 08-28-2014, 11:08 AM
  4. Replies: 2
    Last Post: 06-06-2014, 10:00 PM
  5. input type "hidden" onclick "document.text.submit ...for web login and parsing
    By hgtenn in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-21-2014, 08:40 PM
  6. VBA login to website already but web query didn't know
    By wallstudio in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-06-2012, 01:14 PM
  7. VBA Excel and IE login info "Not Sharing"
    By victoruno in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-17-2009, 08:54 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1