R
Rodg2000
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
(e-mail address removed)
(remove the _nospam to reply)
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
(e-mail address removed)
(remove the _nospam to reply)