Hi, I'd appreciate help from anyone that can point me in the correct
direction here...

I want to open a spreadsheet (call this A) that includes a VB macro, and the
macro will open another spreadsheet (call this B) that will always be stored
in the same directory as spreadsheet A. Now, at one point during a month,
spreadsheets A and B are in one directory, later in the month they gets
moved to a history directory.

What code do I need to use to have the open always point to the directory
that spreadsheet A and B are stored in? Would Curdir be the correct one to
use? Is there a way to retrieve the directory path spreadsheet A is
contained in, and then use that as part of the Open path for spreadsheet B?

TIA for the assistance.

Rodg2000


(remove the _nospam to reply)