topic I suggest you use Insert in Product Forum

Global Send Keys Events Excel Shortcut

matthew_z_willi — Thu, 12 May 2016 17:00:00 GMT

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

I suggest you use Insert

ArchiveUser — Fri, 13 May 2016 12:16:00 GMT

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

Hi Matthew,

john_shiels — Mon, 16 Jan 2017 18:23:00 GMT

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.

Hi Matthew,

MarkIlgovsky1 — Fri, 10 Nov 2017 00:14:00 GMT

Hi Matthew, How did you solve this? Thanks