I am trying to work with excel web query(*.iqy) function to implement a automatic report fetching. But the requested URL will redirect to a login page, and after user/pass submitted, the data page will be shown.

I am not sure how to handle such situation in the iqy part. Is there any one can provide me any suggest?

Thx in advance.