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

Dim bk1 as Workbook, bk2 as Workbook
set bk1 = workbooks.Add
set bk2 = workbooks.add

bk1.Activate
msgbox "Click to continue"
bk2.Activate

--
Regards,
Tom Ogilvy


"Andibevan" wrote in message
...
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

No, all you need to do is to set a workbook object for each workbook as you
add them

Set wb1 = Workbooks.Add
Set wb2 = Workbooks.Add
With wb1
.etc
End With

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Andibevan" wrote in message
...
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