You do not want to reference workbooks by their index (as you have seen).
Your best option is to set workbook objects to the workbook that you are
dealing with. Something like this...

dim wbkTarget as workbook

set wbkTarget = workbooks("MyBook.xls")
wbktarget.select
msgbox "Tada"
thisworkbook.select

--
HTH...

Jim Thomlinson


"RJC" wrote:

When trying to go from one open file/workbook to another within a VB module,
WITHOUT SPECIFICALLY PROVIDING THE FILENAME, I'm getting an almost random
selection of choices. Specifically, my macro resides in 'Window 3' of the 3
open workbooks. If I try "Windows(1).Activate" from within that macro, I
stay in 'Window 3'. I understand this from the perspective (as noted in the
VB materials) that the 'ActiveWindow' is alwasy 'Window 1'. If I then edit
the macro to activate "Windows(2).Activate", it will, sometimes, activate the
"Windows" tab identified 'Window 1'. There are various other 'funny' cases,
which seem to be related to what I sequence I may have opened or accessed the
files, though the file/Windows enumeration as provided under the "Windows"
tab is alwas as noted.

Anybody know anything that might help???

Thanks.
--
Bob C