....and you'll probably want another const for the file path

another was would be to dim a couple of variables as workbooks ...

eg

SET wb1 = workbooks.open(cstrDatabaseWB)
SET wb2 = workbooks.open(someother_cstrDatabaseWB)

then all you need is
wb1.Activate
or
wb2.Activate

seesm easier to me. plus, all you need to close is
wb1.close false ' to close without saving
or
wb2.close true ' to save & close





"Patrick Molloy" wrote:

thats becasue the workbook name in the activate method is just the name and
excludes the path

try
Const cstrDatabaseWB As String = "real1.xls"


"Merlynsdad" wrote:

No, I'm not closing Book1, I'm just activating it and switching back and
forth from Book1 to Book 2 as I copy and paste. If I use the actual name of
the workbook "real1.xls" it works fine. However when I input the constant
cstrDatabaseWB in the command:

Windows(cstrDatabaseWB).Activate

I get a runtime Error 9, "subscript out of range" error.

The constant is currently defined as:

Const cstrDatabaseWB As String = "C:\Documents and Settings\5YPJB\My
Documents\Excel documents\Sherry project\real1.xls"

because I'm writing this on my machine, but the constant will eventually end
up with a network path.


"Patrick Molloy" wrote:

gary's answer is correct if you have two or more workbooks open ... all you
need to do is activate the one that to want to use. Are you now saying that
when you "switch" to book 2 that you actually CLOSE book1? I' m not clear on
thios question.


"Merlynsdad" wrote:

That would do it if it were local, but it's out on a network and I'm
referring to it with Constant "cstrDatabaseWB". Using the constant either
with the "" or without doesn't work. I forgot to mention I'm also running the
code in the click event of a listbox.

"Gary''s Student" wrote:

Windows("Book2").Activate
or
Windows("Book2.xls").Activate

depending on what is in the Window Title Bar.
--
Gary''s Student - gsnu200908


"Merlynsdad" wrote:

I'm switching back and forth between two workbooks. I open Book1 from the
ThisWorkbook_Open event in Book2, then switch back to Book2 with a
Me.Activate since I'm still in it. How do I switch back to the already opened
Book1? Presumably this is also how I would switch back to Book2 while in
Book1?