Using different Terminalkeys in VBA

jam1531

New Member
Joined
Jan 5, 2015
Messages
29
Hi,

I have some code that was passed down to me at my company. The code logs onto one of our servers (IBM Host, I believe). Essentially anything that I would normally have to hand type in the program I can get Excel to do via VBA.

There are certain functions, however, that I cannot seem to complete because I do not know what the terminal key number should be.

For example: I need to know how to tell the code to transmit terminal key F4 and F14. A lot of people have told me to use things like .TransmitTerminalKey rcIBMEnterKey for enter and other similar commands, etc. Such command do not work. I have noticed that all of the commands that whoever made the code inserted are numeric. Here are some examples.

.TransmitTerminalKey 277 'Escape

.TransmitTerminalKey 289 'Enter

.TransmitTerminalKey 405 'Tab

.TransmitTerminalKey 379 'Next Page (i.e. F3 I think)

Does anyone know where I can get a list of Keys and what their corresponding numbers are in this code? Or at least what F14 and F4 are? Thanks!


 

Excel Facts

Spell Check in Excel
Press F7 to start spell check in Excel. Be careful, by default, Excel does not check Capitalized Werds (whoops)

Forum statistics

Threads
1,215,024
Messages
6,122,729
Members
449,093
Latest member
Mnur

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top