 <p>I don't have a spotify account so, not sure with the user name password. But their doc says that they have REST implementation, so your credentials need to be 64 bit encoded.</p> <p>In this line <code>HttpRequest.SetRequestHeader "Authorization", "Basic " &amp; strClient_secret</code></p> <p>the variable <code>strClient_secret</code> needs to be 64 bit encoded. </p> <p>so try adding a function like this, while replacing the place holders with correct user name and password.</p> <pre><code>Private Function EncodeBase64() As String arrData = StrConv(&lt;&lt;YOUR_SPOTIFY_USERID&gt;&gt; &amp; ":" &amp; &lt;&lt;YOUR_SPOTIFY_USERPASS&gt;&gt;, vbFromUnicode) Set objXML = New MSXML2.DOMDocument Set objNode = objXML.createElement("b64") objNode.DataType = "bin.base64" objNode.nodeTypedValue = arrData EncodeBase64 = objNode.text Set objNode = Nothing Set objXML = Nothing End Function </code></pre> <p>then change the line above to : <code>HttpRequest.SetRequestHeader "Authorization", "Basic " &amp; EncodeBase64</code></p> <p>have a look here for REST and VBA: <a href="http://ashuvba.blogspot.com/2014/08/excel-vba-json-rest-with-jira-json-is.html" rel="nofollow">http://ashuvba.blogspot.com/2014/08/excel-vba-json-rest-with-jira-json-is.html</a></p> <p>It will set you on correct route hopefully.</p>