+ Reply to Thread
Results 1 to 6 of 6

Internet Windows Security POPUP

  1. #1
    Forum Contributor
    Join Date
    08-27-2009
    Location
    South Africa
    MS-Off Ver
    Office 2010
    Posts
    217

    Question Internet Windows Security POPUP

    Good Morning

    I have a code that opens a website inserts the username and password tabs x3 and enter. When I use this on a normal website it works great but on one of my sites the username and password needs to be inserted on a Windows security popup screen. The info I have on the OK button on the pop up is:

    Title: Windows Security
    Class: #32770
    Instance: 2

    I cannot get my code to do anything on this popup. Here is my code:

    Please Login or Register  to view this content.
    The second problem I have is that when I am logged on I cannot simply download the data table.... I have to use:
    Please Login or Register  to view this content.
    to copy the whole page and then open my excel sheet and then paste. How will I be able to get this data from a page without a normal table?

    Thanks

  2. #2
    Forum Contributor
    Join Date
    08-27-2009
    Location
    South Africa
    MS-Off Ver
    Office 2010
    Posts
    217

    Re: Internet Windows Security POPUP

    Just want to add that this code works perfectly when there is no popup.

  3. #3
    Valued Forum Contributor
    Join Date
    08-29-2012
    Location
    In lockdown
    MS-Off Ver
    Excel 2010 (2003 to 2016 but 2010 for choice)
    Posts
    1,766

    Re: Internet Windows Security POPUP

    I recently had the same problem (trying to enter a username and password into a Windows Security popup on a website). I eventually solved it. My sub below. This needs to be called after sending the click Next button. I found that I must not wait for READYSTATE_COMPLETE just before the Windows Security popup appears (use Application.Wait instead)

    Please Login or Register  to view this content.
    *******************************************************

    HELP WANTED! (Links to Forum threads)
    Trying to create reusable code for Custom Events at Workbook (not Application) level

    *******************************************************

  4. #4
    Valued Forum Contributor
    Join Date
    08-29-2012
    Location
    In lockdown
    MS-Off Ver
    Excel 2010 (2003 to 2016 but 2010 for choice)
    Posts
    1,766

    Re: Internet Windows Security POPUP

    Let me know if I have solved your first problem (Windows Security popup)

    I have an idea for your 2nd problem

  5. #5
    Registered User
    Join Date
    05-15-2014
    MS-Off Ver
    Excel 2003
    Posts
    1

    Re: Internet Windows Security POPUP

    @mc84excel

    Where exactly do you call this at? I have the code below and assume that you would call it after:

    Please Login or Register  to view this content.
    For some reason when I use the With Application code, it sees the application as Microsoft Excel and inputs the username into the VB Editor screen.

    Please Login or Register  to view this content.
    Last edited by cgayton; 05-15-2014 at 11:05 AM.

  6. #6
    Valued Forum Contributor
    Join Date
    08-29-2012
    Location
    In lockdown
    MS-Off Ver
    Excel 2010 (2003 to 2016 but 2010 for choice)
    Posts
    1,766

    Re: Internet Windows Security POPUP

    Quote Originally Posted by cgayton View Post
    For some reason when I use the With Application code, it sees the application as Microsoft Excel
    SendKeys is a very bad way of doing things because it sends the keystrokes to whatever window is currently active. It is essential you don't touch the keyboard or mouse while the code is running.

    Dummy example of calling sub below:
    Please Login or Register  to view this content.

    I am using these subs below:
    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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