title: Problem with Open method of MSXML2.ServerXMLHTTP.6.0 PATCH request
body: <p>I have been using MSXML2.XMLHTTP.6.0 successfully with my Excel VBA script for a couple years, for both GET and POST requests.  The POST request looks like:</p>
  
  <pre><code>Dim zipService as Object
  Dim Query As String
  Dim Body As String
  Set zipService = CreateObject("MSXML2.XMLHTTP.6.0")
  Query = "https://10.xxx.xxx.xxx:443/api/rest/v1/bulk/thresholdRules/"
  zipService.Open "POST", Query, False
  zipService.setRequestHeader "Authorization", "Basic " &amp; gsUserIDPW
  zipService.setRequestHeader "Content-Type", "application/json"     
  zipService.setRequestHeader "Accept", "application/xml"       
  Body = "Body of the request"
  zipService.send (sBody)
  </code></pre>
  
  <p>Now I need to need to make a PATCH request to a new REST call for the same API. I have tested the PATCH REST call in Postman, and it works successfully.  Using PUT in Postman also works.  However, in Excel, when I try to do the Open call using PATCH (or PUT), the Open call fails with a -2147012891 error.  </p>
  
  <p>Any suggestions?  Are PATCH and PUT allowed with the Open method?  Are there other parameters I have to specify?  All the code examples I find online are always GET and POST requests.</p>