title: How to make VBA click a button in a different workbook?
body: <p>Workbook 1 contains Macro 1, which I wrote.  </p>
  
  <p>I'm using Macro 1 to send input data to Workbook 2, and then retrieve calculations from Workbook 2. Workbook 2's calculations require exercising Macro 2, which is activated by clicking a command button Button 6 in Workbook 2.</p>
  
  <p>The button name is "Button 6" and I know the name of the macro it initializes. </p>
  
  <p>How do I click Button 6 from Macro 1?</p>