title: VBA - how to use google form on IE.navigate with process in the background
body: <p>I'm currently using the following code to open an IE instance and navigate a complete-with-answers google form link. By accessing this link, the google form is immediately answered by the "entry.1102259784=XXXX" strings.</p>
  
  <pre><code>Private Sub Workbook_Open()
  
     Application.ScreenUpdating = False
      Dim IE As Object
  
      Call Usernames
  
      Set IE = CreateObject("InternetExplorer.Application")
      IE.Visible = False
      IE.Silent = True
  
      IE.Navigate Cells(7, 1)
  
      While IE.Busy
          DoEvents
      Wend
  
      IE.Quit
      Set IE = Nothing
  
  End Sub
  </code></pre>
  
  <p>Its quite simple and works well (hidden and fast) except for this particular instance (google forms), as the IE opens and just stands there with the "Your form has been submitted" webpage on display. </p>
  
  <p>The idea is to submit information about who is opening the file and when to a google spreadsheet. </p>
  
  <p>I would appreciate any help on this matter.</p>
  
  <p>Thank you very much!</p>