Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Queries from web sites that require login
I would like to run a query in Excel that gets data from a website
table, that requires the user to be logged in to the site first. At the moment, I get around this by right clicking on the cell that "contains" the web query to edit the query. A window pops up that allows me to 'edit' the table downloaded by the query. I use this window to login to the website and navigate to the correct page on the site. Once on the correct page at the site, I click "cancel" on the edit web query window to close it. I can now run the web query from the page using VBA scripts to do so. Is there any way I can get Excel to send the relevant login and password information to the site before running the query? Or is there a better way to achieve my goal? Any help is appreciated. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Queries from web sites that require login
Hi, have the same problem and cant get any further. My web query is complete (in VBA) but the problem is that i dont get the user+pass passed on to the site so my return in excel is "email, user, forgotten your password.." instead of "real data" :( Any help very much appreciated. Thx ice -- icepick4k ------------------------------------------------------------------------ icepick4k's Profile: http://www.excelforum.com/member.php...o&userid=30054 View this thread: http://www.excelforum.com/showthread...hreadid=395656 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table Sites | New Users to Excel | |||
Pivot Table Sites | New Users to Excel | |||
Get data from other sites | Excel Discussion (Misc queries) | |||
external web query? (sites that require login) | Excel Discussion (Misc queries) | |||
Template Web Sites | Excel Discussion (Misc queries) |