Microsoft KB Archive/89642

{|
 * width="100%"|

Excel: FORMAT is Fourth Argument in OPEN Function

 * }

-

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 &quot;Microsoft Excel Function Reference Guide&quot; 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.