I'm stumped
 

I need to import data into excel via a web query. The problem is I
have to log in to get the information. Is there anyway I can make
excel query me for the login name and password and then get the data?
Eventually I plan to make this all through VBA but for now I'm just
trying to get the fundamentals down. Please help!