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