Microsoft KB Archive/57195

Excel: FOPEN Incorrectly Returns #VALUE PSS ID Number: Q57195 Article last modified on 02-12-1993 PSS database name: W_eXceL

2.00 2.01 2.10 3.00

WINDOWS

Summary:

In Microsoft Excel, the FOPEN function does not always work as intended.

Microsoft Excel 3.0
Page 78 of the “Microsoft Excel Function Reference” for version 3.0 states that the macro function FOPEN(,) returns #N/A when the  is not found.

When using Microsoft Excel 3.0 for Windows, FOPEN incorrectly returns #NAME? when  is 1 or 2 and  is not found. This problem does not occur in Microsoft Excel 3.0 for OS/2.

Microsoft Excel 2.x
Page 279 of the “Microsoft Excel Functions and Macros” for Microsoft Excel for Windows version 2.0 states that the macro function FOPEN(,) returns #N/A when  is not found.

FOPEN incorrectly returns #VALUE when  is 1 or 2 and  is not found. This problem does not occur with Microsoft Excel 2.2 for OS/2.

Microsoft has confirmed this to be a problem in Microsoft Excel for Windows versions 2.0, 2.01, 2.1, and 3.0 and was corrected in version 4.0.

Additional reference words: 2.0 2.00, 2.01 2.1, 2.10 3.0 3.00

Copyright Microsoft Corporation 1993.