Sendkeys command to press Windows Security button

[datamster]

Hello,

I have a workbook that receives its data from a webpage but also requires a username and password. I'd like the workbook to be run by task scheduler but the issue I'm having is when using task scheduler a windows security box opens prompting for username and password. I've checked the box for the credentials to be remembered, which it does, but a key press is required to hit OK. So far I've tried

SendKeys "~", True
ActiveWorkbook.RefreshAll

Which only presses the enter key before the security window pops up and

ActiveWorkbook.RefreshAll
SendKeys "~", True

has the security window popping up before the enter key is pressed and access to excel isn't allowed until the security window goes away. Is there a way to sleep the sendkey command for a few seconds and skip to the next VBA line so when the security window opens the sendkey command is being sent?

 

[John_w]

See if this helps:

Connection to a secure site for which the username and password are to be given on a popup

Hello everybody, I am trying to write a macro that allows an Excel file to connect a secure website. The problem is that the username and the password are not to be given directly on the website but on a popup that appears automatically. Could somebody help me, please? I don't know how to...

www.mrexcel.com

The code, posted on the old forum, is difficult to read. The first part is a VBScript (.vbs file) which finds the authentication window and populates the username and password boxes, then tabs to the OK button. I expect you would only need to tab to the OK button, using oWSH.SendKeys "{TAB}" as many times as needed. Your macro runs the VBScript using the Shell command, like this:

    Const Q As String = """"
    
    Shell "wscript.exe " & Q & "C:\path\to\Login.vbs" & Q