Re: Using XMLHTTPRequest within Firefox (Newbie)

"Dave F." <[email protected]> wrote in message
news:[email protected]...
> Martin Honnen wrote:
> > Dave F. wrote:
> >
> >> I use MSXML.XMLHTTPRequest in an Excel VBA routine to download info
from
> >> a web page using responseText.
> >>
> >> I'd like to swap over from IE & use Firefox instead. Is this possible?
> >
> > If you use MSXML.XMLHttpRequest in an Excel VBA then you are not using
> > IE at all, you are using VBA and MSXML. So I don't understand what you
> > are doing where you would want to switch from IE to Firefox.
> >
>
> Err...
> Please correct me if i'm wrong but I thought MSXML was a part of the Web
> browser install.
>

Installing IE will install MSXML but there are other things that install
MSXML or indeed MSXML may be installed independantly.

>
> Due to the vagaries of IE7, the secure web page I wish to download from
> requires me to manually logon first.
> It won't let me do this via "post".
>
> I have to do this using IE7. I've tried FF 7. It doesn't work.

Whats FF 7?

>
> Snip of code:
>
>    Dim http As New MSXML.XMLHTTPRequest
>    http.Open "post", "http://www.advfn.com/blah,blah,blah", False,
> "Username", "Password"
>    http.send
>    Str = http.responseText
>

this code is using MSXML.  It isn't using a browser of any sort.

> If you know of a better way please tell me. preferably with FF.
>

Have you tried just using a GET instead of post or have you tried "POST"
instead of "post"?  You don't appear to be sending any data so GET would
seem to be the more likely method.

FF doesn't offer you anything here that can help.

-- 
Anthony Jones - MVP ASP/ASP.NET