Hi,

I still haven't managed to solve this one, I would be delighted to hea
any further suggestions.

To summarise the problem: I want to get tables of data from known URLs
but am prevented by a username and password prompt. I have a usernam
and password.

The URL is: http://miranda.hemscott.com/servlet...;companyid=3407

I have attached the source code, which might be necessary if anyone ca
figure out what I need to add to the .iqy file.

This is the bit I think is important:

<td class="tablesubheader"Password:</td<t
class="tabledataright"<input tabIndex="2" class="inputtabledata
name="password" style="width: 150px" type="password"</td<t
class="tableblank"<input type="button" name="passwordhint
value="Request Password Hint" onclick="getPasswordHint()
class="submittableblank"</td

Any ideas?

Thanks,

Berti

Attachment filename: hssession[1].txt
Download attachment: http://www.excelforum.com/attachment.php?postid=65690
--
Message posted from http://www.ExcelForum.com