If you don't require a secure username and password the VBA Reference/
DOM that comes with installing MSXML 6.0 can read XML directly from a
URL.

In that case you wouldn't be using SOAP but you'd be reading XML.

You could put a username and password in the query string.