Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to record a New Web Query that requires login + password.
The Particulars:
I want to record a macro that accesses personal stock data and places that data in a worksheet. The problems arise in two places. First, how to get Excel to pass my userid, generally SS#, and password to the log on screen. I've manually done this after using Data-Import External Data-New Web Query, placing the home screen URL in the address logging in, selecting the table via the yellow arrows and clicking Import and OK. This gets the second problem which is an Excel error saying "Unable to open" followed by the URL and the parameters ending with "Cannot download the information you requested". I have no problem getting this data using IE and doing it all manually. I just don't want to Copy-Paste-Save then crank up Excel, Import and edit when I should be able to run a macro. The General Question: How can I get Excel to record and execute a macro using New Web Query that accesses data requiring a log on and password? A pointer to a web site, internet article or book would be greatly appreciated. All my searches so far have lead to the easy examples of downloading data from public access sites ( I can get stock data from MoneyCentral and Yahoo using Web Query). Thanks for your time, J e r |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to record a New Web Query that requires login + password.
J e r,
Can you add your ID and password to the end of the URL as parameters to pass ? NickHK "J e r" wrote in message ... The Particulars: I want to record a macro that accesses personal stock data and places that data in a worksheet. The problems arise in two places. First, how to get Excel to pass my userid, generally SS#, and password to the log on screen. I've manually done this after using Data-Import External Data-New Web Query, placing the home screen URL in the address logging in, selecting the table via the yellow arrows and clicking Import and OK. This gets the second problem which is an Excel error saying "Unable to open" followed by the URL and the parameters ending with "Cannot download the information you requested". I have no problem getting this data using IE and doing it all manually. I just don't want to Copy-Paste-Save then crank up Excel, Import and edit when I should be able to run a macro. The General Question: How can I get Excel to record and execute a macro using New Web Query that accesses data requiring a log on and password? A pointer to a web site, internet article or book would be greatly appreciated. All my searches so far have lead to the easy examples of downloading data from public access sites ( I can get stock data from MoneyCentral and Yahoo using Web Query). Thanks for your time, J e r |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to record a New Web Query that requires login + password.
Nick,
If my ID and password are in the returned URL immediatelt after the log on, its not obvious. I've tried that URL by copying it to address in Excel and it doesn't work. Can that info be returned to the server without ever being displayed ? I'm going to try a phony ID and password and compare that URL against the one I thought was good to see if he's encoding them. Thanks for jogging my mind, J e r |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Showcase Query Login | Excel Discussion (Misc queries) | |||
Excel 2000 required username and password login for database query | Setting up and Configuration of Excel | |||
How to make a Password login screen in excel | Excel Programming | |||
Synchronize network login/password | Excel Programming | |||
Windows Login Password | Excel Programming |