title: how to use SendKeys method in vb script to select everything on page?
body: <p>I am trying to run a vbscript that will load up a html page in chrome and then do control+a which will select everything on the page, with the ultimate view to copy it and then paste it into excel.</p>
  
  <p>this my script so far:</p>
  
  <pre><code>Set WshShell = WScript.CreateObject("WScript.Shell")
  
  Dim iURL 
  Dim objShell
  
  iURL = "C:\Users\Aasfasf\AppData\Local\Temp\TD_80\hpqc\52136023e30\****\121200.html"
  
  set objShell = CreateObject("WScript.Shell")
  objShell.run(iURL)
  
  WScript.Sleep 1500
  
  WshShell.SendKeys "^a"
  </code></pre>
  
  <p>when I run it loads up the html page, but i dont think the control+a command is working as nothing is selected.</p>