I would like to extract information from a my 401k website on a regular
basis and I intend to use an excel web query to do that. But the
website requires a user id and a password in order to access the
information. How can I do this?

Eventually, I would like to set up a macro using VBA for excel so that
each time I open the file, it will provide the website with the user id
and login, extract the data and plot the daily balance.

Any suggestions would be appreciated.