Microsoft KB Archive/72602

{| = Excel: Selecting Parent Directory with the DIRECTORY Command =
 * width="100%"|

Last reviewed: November 2, 1994

Article ID: Q72602

SUMMARY
To select the parent directory of the current directory from within a Microsoft Excel macro, use the command DIRECTORY(&quot;::&quot;). The command sets the current directory to be the parent directory of the previously current directory.

MORE INFORMATION
For example, if the current directory is set to &quot;MacHD:Excel:Files&quot;, where &quot;Files&quot; is a folder in the &quot;Excel&quot; folder, which is on the hard drive &quot;MacHD&quot;, to change the directory to &quot;MacHD:Excel&quot;, use the command:

=DIRECTORY(&quot;::&quot;)
 * }