title: Can a macro in one workbook make changes to another workbook?
body: <p>I defined a macro in one worksheet(internal.xls) as </p>
  
  <pre><code>Public Sub sheet2test()
     Workbooks.Open Filename:="external.xls"
     Windows("external.xls").Activate
     Sheets("Sheet3").Activate
     Range("A5").Value = 5
  
  End Sub
  </code></pre>
  
  <p>Running this code, opens external.xls, and activates its sheet 3. However the Value of 5 is placed in internal.xls and not external.xls. How do i ensure that the changes are made to the other worksheet?</p>