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

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

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