Microsoft KB Archive/60729

{| = Excel: DIRECTORY Returns Error When Activating Root Level =
 * width="100%"|

Last reviewed: November 2, 1994

Article ID: Q60729

SUMMARY
To activate the root directory from a macro, the path_text argument must be followed by a colon.

For example, to activate the directory &quot;Hard Disk,&quot; use the following formula:

=DIRECTORY(&quot;Hard Disk:&quot;) For more information on the DIRECTORY function, see page 58 of the &quot;Microsoft Excel Function Reference&quot; version 3.0 manual. If you are using Excel 2.20, see page 213 of the &quot;Microsoft Excel Functions and Macros&quot; version 2.2 manual.
 * }