Append /x:on Causes Excel to Open All Files in a Directory

 Last reviewed: November 3, 1994
Article ID: Q72733
The information in this article applies to:
  • Microsoft Excel for Windows, versions 3.0, 4.0, 4.0a, 5.0

SUMMARY

The following command will cause Microsoft Excel to open all files in <directory name> as soon as Microsoft Excel has finished loading: 

   append /x:on <directory name>

MORE INFORMATION

For example, if the command 

   append /x:on c:\dos
is entered at the DOS prompt or is executed in your AUTOEXEC.BAT file, and then you start the Microsoft Excel program, Excel will then open every file in the C:\DOS directory as soon as Microsoft Excel itself has finished loading. These files will be opened as text files.

Workaround

Disable the Append command. This can be accomplished by typing the following command at a DOS prompt before starting Windows or Excel: 

   append;
Note that the Append command should not be used in any form while running Windows or Windows applications. For more information, query on the words 

   dos and append and utility and windows

KBCategory: kbusage
KBSubcategory:

Additional reference words: 3.0 3.00 4.0 4.00 4.0a 4.00a 5.0 5.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 3, 1994
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.