I've got some code that plus data from another workbook. It works when the files are in the same instance of Excel; however, if I have the file open in an different instance of Excel the macro doesn't find the specified range. Is it possible to activate this workbook without opening it in the current session of Excel. My code is below: thank ahead of time

If MsgBox("Have you saved BigFile as test1.xls and is that file open?", vbYesNo + vbCritical, "WARNING!") = vbYes The
Range(Cells(iRow, 1), Cells(jRow, 12)).ClearContent
Windows("test1.xls").Activate