Send Key Press from Excel to BA

[49ers]

Hello,

Does anyone know if it's possible to send a keypress from Excel VBA to BA?

I'm wanting to execute a shortcut key when certain criteria are met which subsequently changes the look of the ladder interface?

Any suggestions would be greatly appreciated.

Many thanks

[spreadbetting]

A lot of people seem to use auto hot key to do BA tasks, can always give it a go as it's free and can fire it off from VBA.

Code: Select all

shell("C:\Program Files\AutoHotkey\AutoHotkey.exe ""C:\Path\To\Script\AHK_Script.ahk""")

https://www.autohotkey.com/

[49ers]

Oh cool, I'll take a look..

Many thanks!