Excel: SEND.KEYS() Not Executing Correct Menu Commands

 Last reviewed: November 2, 1994
Article ID: Q67578
The information in this article applies to:
  • Microsoft Excel for Windows, versions 2.x, 3.0, 4.0, 5.0
  • Microsoft Excel for OS/2, versions 2.2, 3.0

SUMMARY

When a SEND.KEYS() function in a Microsoft Excel macro is executing an incorrect menu command, check the case of the letters that are being sent by the function. If the letter for the desired menu is capitalized, the SEND.KEYS() function will execute it as a SHIFT+<the menu letter> keystroke, resulting in the wrong menu option.

MORE INFORMATION

When using a line such as 

   =SEND.KEYS("%(F)(C)")
in a Microsoft Excel macro to execute the Close command from the File menu, even though a SHIFT keystroke is not entered in the function, the function will still execute SHIFT+ALT+File, generating the File Close All command. Because the Close and the Close All commands can be called by the letter "c", the File Close All command will be executed rather than the desired File Close command.

(Note: this is also true for version 5.0 macro sheets, but not modules.)

KBCategory: kbusage
KBSubcategory:

Additional reference words: 2.0 2.00 2.01 2.1 2.10 2.2 2.20 2.21 3.0
3.00 4.0 4.00 5.0 5.00

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: November 2, 1994
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.