#1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 298
Default XMLHTTP


http://msdn.microsoft.com/en-us/libr...49(VS.85).aspx

Try the username/passowrd parameters in the Open method.

Tim

"Tom" wrote in message
...
Hello,

I'm a newbie and have no experience with XMLHTTP. I found the following
script on the net which works fine:

Sub GetHTTPData()
Dim sURL As String, sHTML As String
Dim oHttp As Object

sURL = "http://www.blabla.com"

On Error Resume Next
Set oHttp = CreateObject("MSXML2.XMLHTTP")
If Err.Number < 0 Then
Set oHttp = CreateObject("MSXML.XMLHTTPRequest")
MsgBox "Error 0 has occured while creating a MSXML.XMLHTTPRequest
object"
End If
On Error GoTo 0
If oHttp Is Nothing Then
MsgBox "For some reason I wasn't able to make a MSXML2.XMLHTTP object"
Exit Sub
End If

'Open the URL in browser object
oHttp.Open "GET", sURL, False
oHttp.Send
sHTML = oHttp.responseText
End Sub

But what I really want is to logon to a secure server. Does anybody know
how I need to enter the logon information? An example would be
appreciated.

Regards,
Tom






Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
xmlHTTP.Send Questions Chris Excel Programming 4 March 5th 09 05:44 AM
MSXML2.XMLHTTP Works with IE6, IE6 SP 1 but not with IE6 SP 2 - wh p3plyr Excel Programming 1 April 17th 07 06:12 PM
xmlhttp and ie cache Jack Clift[_3_] Excel Programming 4 March 11th 05 02:43 AM
XMLHTTP proxy settings. Beto[_3_] Excel Programming 0 April 12th 04 08:29 PM
XMLHTTP proxy settings. Beto[_3_] Excel Programming 0 April 2nd 04 09:52 PM


All times are GMT +1. The time now is 04:08 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"