Enter Vs Return

Re: Enter Vs Return

See SendKeys Statement and SendKeys Method

Application.SendKeys ("~")

Quote

but every one of them is just going onto a new line!

That's what the Enter key does! You cannot run a macro while in Edit mode so you cannot use it to enter a value while in edit mode.

Re: Enter Vs Return

If your emulator is like mine, you can submit to the mainframe by the Right Control key as-well-as the numeric Enter key. The code below uses and API routine to simulate pressing and releasing the Right Control key.

Of course some emulators come with macro tools to create macro text files. One can record a macro to do some of these kinds of things. Once you know the syntax, you can write these as Text files in VBA if needed.

Option Explicit
Declare Sub keybd_event Lib "user32" (ByVal bVk As Integer, ByVal bScan As Integer, ByVal dwFlags As Long, ByVal dwExtraInfo As Long)
Declare Sub Sleep Lib "KERNEL32" (ByVal dwMilliseconds As Long)


' Constant declarations:
Const VK_RCONTROL = &HA3
Const VK_LCONTROL = &HA2
Const KEYEVENTF_EXTENDEDKEY = &H1
Const KEYEVENTF_KEYUP = &H2
Const VK_Tab = 9


Sub Main()
  AppActivate "TitleOfApplicationToActivate", True
  SendKeys "userid", True
  SendKeys "{Tab}", True
  SendKeys "password", True
'Simulate Key Press
keybd_event VK_RCONTROL, &H45, KEYEVENTF_EXTENDEDKEY Or 0, 0
'Simulate Key Release
keybd_event VK_RCONTROL, &H45, KEYEVENTF_EXTENDEDKEY Or KEYEVENTF_KEYUP, 0
End Sub