<div>
Question: When you have the two workbooks open... are they running in separate instances of Excel or in the same instance? &nbsp; &nbsp;<br />
<br />
The answer to your question will be quite a bit different if you need to reach across instances of excel.<br />
<br />
If the workbooks are in the same instance of excel, then you will only be able to see workbooks one at a time in the same window.<br />
<br />
If the workbooks are in different instances of excel, then you can have the both open at the same time in different windows.
</div>


Question: When you have the two workbooks open... are they running in separate instances of Excel or in the same instance?    

The answer to your question will be quite a bit different if you need to reach across instances of excel.

If the workbooks are in the same instance of excel, then you will only be able to see workbooks one at a time in the same window.

If the workbooks are in different instances of excel, then you can have the both open at the same time in different windows.

<div>
Hi ken.<br />
<br />
Always in the same instance<br />
<br />
Regards
</div>


Hi ken.

Always in the same instance

Regards

<div>
<div class="content wysiwyg-content">
can an expert provide me with the vba code to make an open workbook an active workbook.<br />
<br />
So, I am in a workbook [lets call it ABC] that has a macro. this workbook needs to refer to another [open] workbook [Lets call that XYZ] <br />
<br />
So ABC needs to switch between ABC and XYZ and back from time to time throughout the Macro Process. I thinking that rather than refer to ABC and XYZ I should refer to ThisWorkbook and ????? [XYZ as ??Workbook]<br />
<br />
Thanks
</div>
</div>


can an expert provide me with the vba code to make an open workbook an active workbook.

So, I am in a workbook [lets call it ABC] that has a macro. this workbook needs to refer to another [open] workbook [Lets call that XYZ] 

So ABC needs to switch between ABC and XYZ and back from time to time throughout the Macro Process. I thinking that rather than refer to ABC and XYZ I should refer to ThisWorkbook and ????? [XYZ as ??Workbook]

Thanks

make an open workbook an active workbook

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.