Refreshing a web query that is behind a password

I am working on a project where I need to access some data behind a login and password. I used sendkeys to input the login and password when I created the web query in VBA. This worked fine, however when I try to refresh the query using the same technique I can't get it to work. Is there something that I need to adjust with the sendkeys or is there another way to achieve my goal that would work better

Answer this question

Refreshing a web query that is behind a password

  • Refreshing a web query that is behind a password