Excel: #VALUE Error Returned by Workgroup Extensions Functions

Last reviewed: September 12, 1996
Article ID: Q99658
The information in this article applies to:
  • Microsoft Excel for Windows, versions 4.0 and 4.0a
  • Workgroup Extensions Kit for Microsoft Excel

SUMMARY

In Microsoft Excel, the macro functions provided with the Workgroup Extensions Kit may return a #VALUE error if the [Mail] section of the Windows for Workgroups WIN.INI file is missing. In order for these functions to operate correctly in Microsoft Excel, the WIN.INI file must contain the following lines:

   [Mail]
   MAPI=1

MORE INFORMATION

The MAPI=1 line in the WIN.INI file is used to inform other mail-enabled applications that the Messaging Application Program Interface (MAPI) is present on this workstation. This entry is written by the Mail program that comes with Windows for Workgroups when you run Mail for the first time. An entry of 1 identifies that the MAPI functions are present on this workstation, while an entry 0 is used to inform other applications that the MAPI support functions are not present.

Most macro functions provided by the Workgroup Extensions Kit will return a #VALUE! error value if any error occurs while performing that operation. The GET.MAIL(1) command can be used to return more information on the last error generated. In the case of a missing MAPI=1 line in the WIN.INI, the GET.MAIL(1) function will return the value 1001. This corresponds to MAPI not installed.

REFERENCES

Windows For Workgroups Resource Kit version 3.1, Page 6-15 Workgroup Extensions Kit for Microsoft Excel, Page 7


KBCategory: kbinterop
KBSubcategory:

Additional reference words: 4.00 4.00a WAKIT



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: September 12, 1996
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.