title: VBA call webpage without opening browser or returning data
body: <p>I am trying to create an excel UDF that calls a web page that runs scripts which take values from parameters in the URL. EG: "<a href="http://example.com.com/script.php?variable1=123&amp;variable2=456&amp;etc=etc" rel="nofollow noreferrer">http://example.com.com/script.php?variable1=123&amp;variable2=456&amp;etc=etc</a>"</p>
  
  <p>I have used this after much googling and trying things from other stackoverflow answers. yes it creates a udf, yes you can enter a cell value in the udf, but no it does not call the URL (visits tracking on the URL says it has not been called).</p>
  
  <pre><code>Function callurl(urltocall As String) As String
  Dim urlText As String
  With CreateObject("MSXML2.XMLHTTP")
  .Open "GET", urltocall, False
  .send
  urlText = .responseText
  End With
  End Function
  </code></pre>
  
  <p>I do not need it to return any data, just to call the URL to run the script. The point of doing this is to take variables from excel and use them as parameters in the URL which will run a script and update a web SQL database.</p>
  
  <p>The actual result was nothing (blank cell in excel, no visit to webpage).</p>
  
  <p><a href="https://i.stack.imgur.com/OCQFs.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/OCQFs.png" alt="enter image description here"></a></p>