Hi gimme_this_gimme_that;
I'm looking some function working with an ie object.
Now I can open the ie object webpage, even without provide UserId and password
I'm thinking I could get the specific information I need from this ie
Object, But,
One thing is that I don't know how the ie object methods and properties
work, basically cause I don't have it referenced in Excel Library, I don't
see a file or dll for that in the references library. For example to use a
find method in the ie object and then to refer to the field/cell next to the
parameter that I'm requesting with the find method.

In a sheet i could do it, but again when i execute
workbooks.open("http//aaaa/.bbb.com"), in that moment and part of the code it
prompts me with the logon dialog box. I guess Excel got a cookie like Randy
mentioned before cause now I see the values already provided into the form,
but the i have the Enter command. I mean do not have an idea how to work it
out, even when I open the webpage with the ie object function.
--
Edgar Rey


" wrote:

It sounds to me like the username and password are associated with a
setting in the web server.

For example, in Apache a Software Engineer can put a .htaccess file in
a directory with static content (the Workbooks). This file has a list
of usernames and passwords. (.htaccess files can access a database for
name/password pairs too.)

When users a access documents in that directory they get prompted for
their username and password.

If this is what's going on. And it sounds like it is. You may or may
not be able to work around..

What you have to do is get one of those applications that sniffs the
communication between your browser and the web server. Then write code
that reads and writes to a socket interacting with the webserver the
same way a human would.

Perl could do it. Java could do it. Normally getting the entire thing
going is a day's work. The tedious part is getting the linefeeds just
right. There is more than one line feed character and often it's hard
to tell which one it's using.

Of course for you the prefered solution would be to use WScript or
some other PowerShell language. ( I don't know if WScript gives you
read and write sockets - it probably does.)

Looks like Randy is hoping you can do about the same with an IE
Object.