Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Refreshing web query that is password protected
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Refreshing web query that is password protected
Craig,
If you know the format of the URL that is sent to the server when {ENTER}is clicked, use .PostText to send that. e.g. querytable.posttext="?Login=xxxx&Password=whatever " Or something like that. NickHK "Craig" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
password protected page not opening by web query | Excel Worksheet Functions | |||
How can I use web query with a password protected page? | Excel Programming | |||
Web query on password protected page | Excel Programming | |||
Web Query - UserID/Password Protected Textbox | Excel Programming | |||
Refreshing an external query on a protected sheet | Excel Programming |