STEP() Function Prevents SEND.KEYS from Working Correctly

ID: Q62347

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 "test" 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("TEST~")
   =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 :