title: Request to a public Google Form returns Access Denied: HTTP
body: <p>I am trying to use MS Excel to automate the filling up of the Google Form, but I have problem with access, the same code was working before and I did not change anything. here is the code:</p>
  <pre><code>Sub postGoogleData()
  Dim params As String, url As String
  
  url = &quot;https://docs.google.com/forms/u/0/d/e/1FAIpQLSejadFloQF5V69ZZ1fc1kManOZ_vMw8kq10-56ENroZ4c6xiw/formResponse&quot;
  params = &quot;entry.1880992192=&lt;NAME&gt;&amp;entry.2125520249=&lt;IG&gt;&amp;entry.1421191722=&lt;E&gt;&amp;entry.1858469755=Option+1&amp;entry.1858469755=Option+2&amp;dlut=1632409237551&amp;entry.1858469755_sentinel=&amp;fvv=1&amp;draftResponse=%5Bnull%2Cnull%2C%22-829268773860757612%22%5D&amp;pageHistory=0&amp;fbzx=-829268773860757612&quot;
  
  params = Replace(params, &quot;&lt;NAME&gt;&quot;, Range(&quot;A1&quot;).Value)
  params = Replace(params, &quot;&lt;IG&gt;&quot;, Range(&quot;A2&quot;).Value)
  params = Replace(params, &quot;&lt;E&gt;&quot;, Range(&quot;A3&quot;).Value)
    
  ' add a reference to Microsoft XML 6.0 (tools...reference...microsoft XML v6.0_
  
  Dim http As New MSXML2.XMLHTTP60
  
  http.Open &quot;POST&quot;, url, False
  http.setRequestHeader &quot;content-type&quot;, &quot;application/x-www-form-urlencoded&quot;
  http.send params
  
  End Sub
  </code></pre>
  <p>I received the error <code>Access Denied</code>. I changed the Internet Explorer Options: Internet Options Security &gt; Custom Security Level &gt; Miscellaneous &gt; Access Data Sources Across Domains &gt; Enable. This removed the error but my Google Form wasn't populated.</p>
  <p>I have tried <code>MSXML2.ServerXMLHTTP60</code> but this didn't populate the Google Form either.</p>
  <p>Here is the <a href="https://docs.google.com/spreadsheets/d/1Cbrn5BID2m4nlbm9imBu_etf5nWE3TGkYefu7DTsTRY/edit?usp=sharing" rel="nofollow noreferrer">spreadsheet</a> that contains the summary of all the responses. Here is the <a href="https://docs.google.com/forms/d/e/1FAIpQLSejadFloQF5V69ZZ1fc1kManOZ_vMw8kq10-56ENroZ4c6xiw/viewform" rel="nofollow noreferrer">Google Form</a>. My objective is to use Excel to automate the filling up of the Google Form. This code used to work before but I encountered the <code>Access Denied</code> error in files that used to work before. Could it be because of changes that Google must have implemented in their web-services?</p>
  <p>I appreciate your help. Thank you.</p>