View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Mike[_49_] Mike[_49_] is offline
external usenet poster
 
Posts: 19
Default Browsing to URL and reading contents

On Tue, 18 Nov 2003 at 16:00:49, Jake Marx (Jake Marx
) wrote:
You can use the MSXMLHTTP object:

Sub test()
Dim xml As XMLHTTP40

Set xml = New XMLHTTP40

xml.Open "POST", "http://www.chambersharrap.co.uk/" & _
"chambers/wwizards/wwizards.py/main"
xml.setRequestHeader "Content-Type",
"application/x-www-form-urlencoded"
xml.send "sword=test"
Debug.Print xml.responseText
Set xml = Nothing
End Sub

It does seem much faster, but I don't know what it's doing behind the
scenes. I assume it's using the core libraries IE does without actually
instantiating the IE application. I don't think it will be installed on all
machines, so you may have to distribute the library for your users.

Jake - you are a star

It needs a slight bit of tweaking in the middle before I check
responseText and I've had to use version 3.0 with Office 2000
--
Mike
Please post replies to newsgroup to benefit others
Replace dead spam with ntl world to reply by email