Microsoft KB Archive/62347

{|
 * width="100%"|

STEP Function Prevents SEND.KEYS from Working Correctly

 * }

-

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, 2.21, and 3.0

-

SUMMARY
If the STEP function is placed before a SEND.KEYS function in a Microsoft Excel macro, the SEND.KEYS function may fail to work as expected.

The following macro enters the word &quot;test&quot; into the active cell. The macro performs its function without the STEP command, but the SEND.KEYS command is ignored if the STEP function is entered first.

  =STEP =SEND.KEYS(&quot;TEST~&quot;) =RETURN

To avoid this behavior, use STEP after the SEND.KEYS function or remove the STEP function.

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

Additional query words: 2.0 2.00 2.01 2.1 2.10 3.0 4.0

Keywords :

Version :

Platform :

Issue type :

Technology :