Hi Jan Karel and other experts,

I have a similar challenge -- I want to download data from a wevbsite that requires logging in with a username and password.

When I log in and then click on "Refresh All" for my Web Query it tries to open the pass word protected website; which, of course, it cannot do.

Is there a way to edit the Web Query so it does not try to open the entire website; but rather just goes to that page of the website where the data is.

Or if it is not possible to edit Web Query; is there another approach that would work in this situation?

(I'm using Excel 2010.)

I'll appreciate very much your suggestions!

/ Gary E.