title: Update an excel sheet using VBA/ADO
body: <p>When I execute this function I get a run time error, "Operation must use an updateable query". What is causing it?</p>
  
  <pre><code>Function updateConfigFile(strQuery As String)
  
  Dim cnn As ADODB.Connection         
  Dim objMyCmd As ADODB.Command
  
  Set cnn = New ADODB.Connection
  Set objMyCmd = New ADODB.Command
  
  constConfigFile = "MyWorkbookName"
  
  With cnn
  
      .Provider = "Microsoft.Jet.OLEDB.4.0"
      .ConnectionString = "Data Source=" &amp; ActiveWorkbook.Path &amp; constConfigFile &amp; ";" &amp; _
          "Extended Properties=""Excel 8.0;HDR=Yes;IMEX=1"";"
      .Open
  
  End With
  
  strQuery = "update [test$] Set [test]='Hello' WHERE [Test]='h'"
  
  objMyCmd.CommandType = adCmdText
  objMyCmd.CommandText = strQuery
  objMyCmd.ActiveConnection = cnn
  
  objMyCmd.Execute
  
  
  Set objMyCmd = Nothing
  Set cnn = Nothing
  
  
  End Function
  </code></pre>