How can I use web query with a password protected page?

C

claytorm

Hi

First, thanks to Jake Marx for helping with my previous web quer
problem.

I want to retrieve some financial data from a site which I subscrib
to. As this is password protected, if I simply place the URL of th
data in the query, the query loads the password prompt page.

Could someone point me in the right direction? Is it possible to writ
some sort of script which would fill my password in automatically, the
retrieve the required data? Any hints, however general, would be mos
welcome.

Bertie
 
C

claytorm

I couldn't get this to work - most likely because of my lack o
knowledge about VBA. In which exact part of this should I enter my use
name and password?

WEB
1
http://mywebsite.com/eQA_dev/eqapro.nsf/HSGCASTally?
OpenView&UserName=["User Name","Enter your user name."]
&Password=["Password", "Enter your password."]

I also read somewhere (I can't find the link now) that it might b
possible to alter the URL in the format
http://username:[email protected]

Does this make sense to anyone?

Berti
 
D

Dick Kusleika

claytorm > said:
I couldn't get this to work - most likely because of my lack of
knowledge about VBA. In which exact part of this should I enter my user
name and password?

WEB
1
http://mywebsite.com/eQA_dev/eqapro.nsf/HSGCASTally?
OpenView&UserName=["User Name","Enter your user name."]
&Password=["Password", "Enter your password."]
Click to expand...

Bertie. You can enter your username and password in place of the bracketed
items. Or you can leave the bracketed items and it should prompt you for
the username and password. If you are prompted, you will have the
opportunity to save what you type for future refreshes. This really doesn't
have anything to do with VBA, it's an iqy file.
I also read somewhere (I can't find the link now) that it might be
possible to alter the URL in the format:
http://username:[email protected]
Click to expand...

I've heard that too. I've also heard that some recent versions of IE don't
allow that anymore.
 
C

claytorm

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://tinyurl.com/49yes

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=65650
 
Top