Microsoft KB Archive/66425

Quotation Marks Not Allowed in Value Field of ’LE Command Code PSS ID Number: Q66425 Article last modified on 04-08-1991 PSS database name: D_MPlan

3.00 4.00 4.01 4.20

MS-DOS

Summary:

If you use the ’LE command code within a macro and attempt to enter a function containing an argument enclosed in quotation marks (&quot;) in the variable, an error highlight indicating that the character is invalid will occur on the quotation mark.

More Information:

Example
The macro command “’LER1C1’TEXT(NOW,”yyyy“)” should place the current year in cell R1C1. The “TEXT(NOW,”yyyy“)” function is correct and will work properly outside of the macro; however, within the ’LE macro command code, an error highlight will be placed on the quotation mark preceding yyyy.

Page 166 of the “Microsoft Multiplan User’s Guide” for version 4.20 indicates that the variable in the ’LE command code can be anything you can enter on the command line using the Value command. This is incorrect as noted above.

Microsoft has confirmed this to be a problem in Multiplan versions 3.00, 4.00, 4.01, and 4.02.

Copyright Microsoft Corporation 1991.