Poll of the Day > excel question

(+) Yeah! (+)

so I have a program which accept values pasted into it. is there way to paste a keyboard command? i usually just type in everything in excel. each space is counts and an enter. i was wonder if i can copy f9 key prompt.
---

yes it's a third party program that i can paste excel values into it. the third party program needs the f9 command to accept the values i just pasted. but i don't know how to tell it to do it through a paste.
---

Ugh excel topic
---

Zangulus posted...

Whats the third party program? Did you code it?

no. it's a copy of another program. It's called Putty.

https://www.computerhope.com/jargon/p/putty.htm
---

you can send key presses to the active window using the .NET SendKeys class

https://docs.microsoft.com/en-us/dotnet/api/system.windows.forms.sendkeys?view=netframework-4.7.2

it's a wrapper around the win32 SendInput function, which would be a lot harder to use

https://docs.microsoft.com/en-us/windows/desktop/api/winuser/nf-winuser-sendinput

you'd have to be in something like C#, VB.NET, or maybe PowerShell to use SendKeys.

SendInput would be easiest to call from win32 C++, but you could also call from C# and VB.NET, and maybe from VBA, but it wouldn't be easy.
---

wait, though if you're using putty then you want to send it through SSH or something

there might be some kind of escape sequence that represents F9

https://unix.stackexchange.com/questions/53581/sending-function-keys-f1-f12-over-ssh

seems to say it would be ^[[20~ but I'm not sure. depends which protocol you're using.
---

Sweet thanks
---