Further:

maybe corporate policy s/b adapted.

anyone using excel knows you cant open 2 books with same name.

for excel files it's much wizer to save multiple copies
of the same file in 1 directory, with date and time appended
to filename for "versioning"

a simple SaveCopyAs procedure can take care of it.


--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


shawb wrote :


Basically I have several workbooks with the same name in different
directories for consistency reasons in my organization.

Is it possible from within one of these workbooks to close itself, and
open up another workbook (with the same name but in a different
directory) using a macro.

Or alternatively is it possible to execute a macro in another workbook
from the macros in a workbook? (Ie to temporarily pass control to a
third workbook that closes the current workbook and opens the desired
workbook).

Cheers