|
本帖最后由 ivrdachen 于 2018-3-19 15:37 编辑
POST和GET可以用,但PUT和 DELETE不知道用msxml2.xmlhttp能否可以,或者用哪个组件才可以实现PUT和 DELETE?
http的请求方法请参考这个帖子http://club.excelhome.net/forum. ... s=thread&tid=957419
貌似网上对VBA http请求方面的讨论很少,已经自己搞定了,原来msxml2.xmlhttp不支持put 和delete,要用XMLHTTP60这个,,还有需要在引用里面加上 Microsoft XML V6.0
代码示例如下:
Dim httpObject As New XMLHTTP60
httpObject.Open "DELETE", url, False
httpObject.setRequestHeader "Content-Type", "application/x-www-form-urlencoded"
httpObject.setRequestHeader "X-Requested-With", "XMLHttpRequest"
httpObject.setRequestHeader "api-nonce", nonceStr
httpObject.setRequestHeader "api-key", apiKey
httpObject.setRequestHeader "api-signature", Signature
httpObject.send (postdata)
|
|