Excel: Determining the Location of the Excel Startup Folder

Last reviewed: November 30, 1994
Article ID: Q78870

Summary:

The following macro statement returns the full path to the Microsoft Excel Startup Folder:

  =GET.WORKSPACE(23)

This folder is located in the System Folder with Apple's System 6.x, and in the Preferences Folder with System 7.0. In Excel for Windows, this directory is called XLSTART and is located in the Excel directory.

More Information:

This command is useful in macros designed to save Excel documents in the Excel Startup Folder. Files saved in this folder are loaded automatically when you launch Excel.

The following macro demonstrates how to save the active document under the name "MyFile" in the Excel Startup Folder without changing the active folder:

A1: Create Startup Document A2: =SET.NAME("file_name","MyFile") A3: =SAVE.AS(GET.WORKSPACE(23)&":"&file_name) A4: =RETURN()

Note: In Microsoft Excel for Windows, replace the colon (:) in cell A3 with a backslash (\).

Reference(s):

"Microsoft Excel Function Reference," version 3.0, pages 116-118

KBCategory: kbother
KBSubcategory:
Additional reference words: 3.00

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: November 30, 1994
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.