Web query on password protected page

C

claytorm

Hi,

(I've posted this before, but adding a bit more detail this time)

I want to run a web query on a password protected page. I wa
previously pointed to this as a solution that apparantly sometime
works:

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

Is there anyone with knowledge of VBA who could customize this to m
situation?

The URL I'm trying to access and have the username and password fo
is:
http://tinyurl.com/49yes
When you try to go directly to this page, the URL remains static, bu
the password prompt page appears.

I would be really grateful if anyone can find a solution to this one
It would save literally hours of copy and paste!

Thanks,

Bertie
 
Top