Using Send Keys

In the best of cases, the use of SendKeys should be avoided if at all possible. It is most often used to send key combinations to Excel to activate a menu item or navigate a dialog box. It works by matching the menu item or dialog control accelerator keys, in the same way that you can use Alt+key combinations to navigate Excel using the keyboard. When used in a non-English version of Excel, it is highly unlikely that the key combinations in the SendKeys string will match up with the menus and dialogs, having potentially disastrous results.

0 0

Post a comment