Web query; protected site?!?

[Tom]

Hi

How can I create a web query from a protected site? How to enter the login
and password ? Any ideas?

Tom

 

[Jake Marx]

Hi Tom,

How can I create a web query from a protected site? How to enter the
login and password ? Any ideas?

It depends on what type of authentication the website is requesting. If
it's integrated security (OS-level), then I think you could use the XMLHTTP
object to get the contents of the page and parse it as needed. If it's web
forms security (the username and passwords are entered into textboxes on the
web page itself), then it's a bit trickier, as you have to POST the data to
the form handler and go from there. For either option, you can do a google
groups search on XMLHTTP to get some ideas.

--
Regards,

Jake Marx
MS MVP - Excel
www.longhead.com

[please keep replies in the newsgroup - email address unmonitored]

 

[GysdeJongh]

Hi,
this was here before.See :

From: "Dave" <[email protected]>
References: <[email protected]>
Subject: Re: Download file from URL with password
Date: Tue, 8 Feb 2005 13:58:40 -0500


From: "GysdeJongh" <[email protected]>
Newsgroups: microsoft.public.excel.programming
References: <[email protected]>
Subject: Re: controling Internet Explorer from Excel...
Date: Mon, 13 Dec 2004 22:16:02 +0100

hth
Gys