Global Send Keys Events Excel Shortcut

[matthew_z_willi]

Hi All, I want to use a Excel shortcut to insert a new row at specific points in a spreadsheet, but only when needed, I have figured out a way using Global Send Keys/Events. But it requires me to send the + key. The only plus button that works when I try the shortcut manually is the += button situated next the the backspace button on the keyboard. Is this a possibility? if so what syntax do I use to send this key? Thanks All Matty

[ArchiveUser]

I suggest you use Insert action in MS Excel VBO object. If you insist on using send keys, to send a plus sign use {+} or {ADD}. Check for details here: https://msdn.microsoft.com/en-us/library/system.windows.forms.sendkeys

[john_shiels]

Hi Matthew, How did you manage to send global keys to Excel. I am trying the same but my business object will not attach to an excel file that is currently open. Suggestions welcome.

[MarkIlgovsky1]

Hi Matthew, How did you solve this? Thanks