title: Using Excel VBA Macro To Capture + Save Screenshot of Specific Area In Same File
body: <p>I'm trying to create a macro which uses an ActiveX control button (click) to take a screenshot of my desktop screen and save it within the same excel sheet as the button. How can I create a screenshot 800x600 in size (not full desktop view) and then have it pasted into the left hand side of the same sheet as the button? I have tried this numerous ways including sendkeys (simplest). </p>
  
  <p>I saved the capture process in a module:</p>
  
  <pre><code>Sub PasteScreenShot()
  Application.SendKeys "({1068})"
  ActiveSheet.Paste
  End Sub
  </code></pre>
  
  <p>And then call the sub in the ActiveX button code. The capture works, but I cannot figure out a way to manipulate its area grab or its pasted location on the sheet. </p>
  
  <p>I am trying to automate with buttons rather than using the snipping tool.</p>