Calling an opened workbook in VBA
<p>this is what i currently have, </p>

<pre><code>Dim mastertemp As Workbook
Dim testproject As Workbook

Set testproject = Workbooks("C:\Users\zzz\Documents\Test Project.xlsm")
Set mastertemp = Workbooks("C:\Users\zzz\Documents\MasterTemp.xlsx")

mastersheet.sheets("Sheet1").activate
</code></pre>

<p>the third line of code is giving me subscript out of range, any ideas?</p>

<p>I want to be able to jump between workbooks without the system giving me "workbook is already open, reopening would discard all changes etc" </p>