If I create 2 workbooks using workbooks.add - how do I refer to the first
inserted workbook as the second is active?

Do I need to save the workbooks in order to be able to reference / activate
them?

Any pointers would be appreciated.

Ta

Andi