PDA

View Full Version : Using XMLHTTPRequest within Firefox



Dave F.
10-10-2007, 10:32 AM
Hi

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?
I looked for a Mozilla object library but couldn't see one. Would I have
to load it manually?

I've done some basic Google searching but unearthed nothing to get me
started.

This is the code I'm using at the moment.

Snip of code:

Dim http As New MSXML.XMLHTTPRequest
http.Open "post", http\mywebpage, False, "Username", "Password"
http.send
Str = http.responseText

Please point me in the right direction.

IE6 used to logon automatically using 'post' but since IE7 I have to logon manually first & then dowload the info - A major pain.

Thanks

Dave F.

Norie
10-10-2007, 10:34 AM
Dave

What makes you think you need different code for FireFox?

As far as I know, could be wrong though, this code is not dependent on which browser you use.

Dave F.
10-10-2007, 12:46 PM
Dave

What makes you think you need different code for FireFox?

As far as I know, could be wrong though, this code is not dependent on which browser you use.

MSXML - isn't that Microsoft ?

Norie
10-10-2007, 12:56 PM
Yes.

But where are you running the code?

Dave F.
10-10-2007, 02:28 PM
Yes.

But where are you running the code?

From within an Excel sub procedure.

As I said : IE6 used to logon automatically using 'post' but since IE7 I have to logon manually first. Which made me think it was defaulting to IE.

If you know why it's stopped accepting the password/usename it might help even though to display the web page in IE is much slower than FF.