XL5: Hierarchy of Methods to Change the Working Directory

ID: Q110209

5.00 5.00c WINDOWS kbusage

The information in this article applies to:

SUMMARY

In Microsoft Excel, you can set the working directory without quitting the program.

To set the working directory from within Microsoft Excel:

   1. From the Tools menu, choose Options.

   2. Select the General tab.

   3. In the Default File Location box, type the path for your working
      directory.

   4. Choose OK to accept the change.

When you make this change, the following line is added to your EXCEL5.INI file:

   DefaultPath= <path>

When you make this change, you must start Microsoft Excel again to verify the new default file location. After Microsoft Excel starts, choose Open from the File menu. In the Open dialog box, under Directories, you should see the new path to the working directory.

MORE INFORMATION

Although setting the default file location in the Microsoft Excel Options dialog box overrides the Working Directory setting specified in Program Item Properties in Program Manager, this change does not override the use of a startup switch ("excel /p <path>") in the command line, nor does it override an OpenDir=<path> statement in the EXCEL5.INI file.

The order of precedence for the methods to change the working directory in Microsoft Excel version 5.0 is as follows:

NOTE: When you first install Microsoft Excel 5.0, if an EXCEL4.INI file exists on your computer and if this file contains an OpenDir=<path> statement, the Setup program will set the DefaultPath= statement in the EXCEL5.INI file to the path specified in the EXCEL4.INI file.

KBCategory: kbusage KBSubcategory:

Additional reference words: 5.00 5.00c current dir start pathname

Version           : 5.00 5.00c
Platform          : WINDOWS

Last Reviewed: November 17, 1998