Refreshing web query that is password protected  
Author Message
Cslom





PostPosted: Visual Basic for Applications (VBA), Refreshing web query that is password protected Top

I am trying to refresh a web query that is located on a password protected site. I am trying to use sendkeys to send the login and password to the prompt that comes up (see below code). However the sendkey application is not inputing the information into the prompt. Any ideas on how to fix this

Application.SendKeys "LOGIN" & "{TAB}" & "PASSWORD" & "{ENTER}", True
Sheets("sheet1").QueryTables("14946_10").Refresh BackgroundQuery:=False



Microsoft ISV Community Center Forums2