Thanks,,, now I I've got to do some homework. Basically, I know how to spell
VB. I recorded the macro based on (very) repititious keystrokes, but have no
idea exactly what you've told me to do. 'Not sure which of the terms are VB
terms, which ones are variables, which ones are necessary (I'm guessing
"Tada" is a congratualtions to me,,, I've not earned it yet), how do I
reference the three workbooks I'm trying to sort through and with what
names,,,,,, I'll play with this a while. If I don't get it sorted out, I'll
be back.

Thanks.

Bob C


"Jim Thomlinson" wrote:

It's feeling very... Monday... Thanks Dave!
--
HTH...

Jim Thomlinson


"Dave Peterson" wrote:

Oops.

dim wbkTarget as workbook

set wbkTarget = workbooks("MyBook.xls")
wbktarget.Activate '<--
msgbox "Tada"
thisworkbook.Activate '<--

Jim Thomlinson wrote:

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

--

Dave Peterson