User enters workbook password to input box @ Workbook_Open. If passes, password is held in a string variable. 
strPassword = InputBox("Please enter workbook password.", "Please enter password")
Because the workbook is connected to a SQL database, the user is then prompted via yes/no MsgBox if they would like to update the data. Behind the scenes is simply: 
rngTable.ListObject.QueryTable.Refresh BackgroundQuery:=False
At this point, a "SQL Server Login" dialog is rendered SQL Login Prompt.png.

Properties are such at the username autoloads, and the cursor is actively blinking in the Password box. I need to pass the string variable containing the workbook password into this field and press enter on the user's behalf.

How do I gain control of this window to then manipulate via SendKeys? Another option I'm not thinking of?

Thanks!