title: Excel VBA application.sendkeys "^C", True not working
body: <p>I am using Excel VBA to copy text selection from an Access file (I'd prefer not to get into details as to why). I have it in a Do While loop that SHOULD press the tab key (works), then copies the data (fails), puts it into the clipboard (works), and sets the clipboard information to a variable (works), which then, for debugging purposes, does a debug.print of the variable (works). This is to cycle through a form to get to a "base point" where I can 100% use tabs and such to navigate to other parts of the form. See code please:</p>
  
  <pre><code>AppActivate ("Microsoft Access - Filename that is constant")
  
  X = 0
  Do While X &lt; 14
  Application.SendKeys "{TAB}", True
  Application.SendKeys "^C", True
  
  Sleep (500)
  
  mydata.GetFromClipboard
  cb = mydata.GetText
  
  Debug.Print (cb)
  If Len(cb) = 5 Then
  X = 14
  End If
  X = X + 1
  Loop
  Set mydata = Nothing
  </code></pre>
  
  <p>I've tried getting this to work, but to no avail. What am I doing wrong or perhaps what would be a better solution?</p>