XmlHttpRequest object is used to make HTTP requests in VBA. Learn how to make REST requests from VBA and hande Basic Authentication.
Read this post on codingislove.com