Excel: FORMAT is Fourth Argument in OPEN Function

 Last reviewed: November 30, 1994
Article ID: Q89642
The information in this article applies to:
  • Microsoft Excel for Windows, version 4.0
  • Microsoft Excel for the Macintosh, version 4.0

SUMMARY

Page 307 of the "Microsoft Excel Function Reference Guide" contains a documentation error in the description of the OPEN function. The fourth argument of the OPEN() and the OPEN?() command syntax should be FORMAT, not DELIMITER_NUM. The description for this argument should also refer to the parameter as FORMAT, not DELIMITER_NUM.

MORE INFORMATION

The FORMAT parameter specifies what character (tabs, commas, spaces, semicolons, nothing, or custom) to use in separating values when opening a text file. If this parameter is omitted, Microsoft Excel uses the value currently set in the Text File Options dialog box when you choose Open from the File menu.

REFERENCES

"Microsoft Excel Function Reference," version 4.0, pages 307-308

"Microsoft Excel User's Guide 1," version 4.0, page 48

"Microsoft Excel User's Guide 2," version 4.0, pages 149

KBCategory: kbdocerr
KBSubcategory:

Additional reference words: 4.0 4.00 delimiter

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.