Excel: FORMAT is Fourth Argument in OPEN Function

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

Additional query words: delimiter

Keywords :
Version :
Platform :
Issue type :