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

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

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

Cheer

--
shaw
-----------------------------------------------------------------------
shawb's Profile: http://www.excelforum.com/member.php...fo&userid=1420
View this thread: http://www.excelforum.com/showthread.php?threadid=39089