Application.onkey windows key

[topi1]

Am I correct in assuming that there is no syntax for the windows key with application.onkey? Like there is ^ for Ctrl and + for Shft. I am trying to send "Ctrl+Windows+4". I know Ctrl+Esc works as windows key but since Iam already using Ctrl in the combination, that is not an option. Is there a way to circumvent this by creating separate application.onkey which will fire Windows and then the next step to use that to trigger Ctrl+Win+4.

All this so I can use excel to activate the program in the taskbar #4 location and copy its data. Thank you.

 

[Micron]

Windows key is not in the list of keys that can trigger key events.

Application.OnKey method (Excel)

Office VBA reference topic

learn.microsoft.com

Is there a way to circumvent this by creating separate application.onkey which will fire Windows

I don't know what "fire Windows" means.

My guess is that you'd need to find a Windows API for this, assuming it exists, or just click to make a window active and then run whatever procedure you have.

 

[Micron]

Maybe you need ShowWindow API?

AllAPI.net - Your #1 source for using API-functions in Visual Basic!

Your #1 source for using API-functions in Visual Basic and classes for the .NET runtime!

allapi.mentalis.org

 

[topi1]

Maybe you need ShowWindow API?

AllAPI.net - Your #1 source for using API-functions in Visual Basic!

Your #1 source for using API-functions in Visual Basic and classes for the .NET runtime!

allapi.mentalis.org

I don't know anything about ShowWindow API. Will read up about it. Thank you so much.

 

[Jaafar Tribak]

As pointed out by Micron, in order to intercept the Win key, you will need to use the Win32. This is not easy. It can be done using a keyboard hook or for a more stable workaround, via subclassing a message only window and using the system Raw Input feature.