Thanks for the help. As it turns out it seems my problem is that I was using the shift key as part of the combo of buttons to hotkey the macro. The shift key is causing the sendkeys function to fail.
Can you use SendKey to send a string variable to an app?
Sub test2123()
Dim MtrId As String
MtrId = ActiveCell.Text
AppActivate "Test.txt - Notepad"
SendKeys MtrId, True
End Sub
We are using RUMBA 2000 (CIS), I been looking for a way to move data from a spreadsheet into the application. I want the RUMBA macro to process then hopfully it can activate a VBA module that would parse the data then copy the information to buffer. This will allow the RUMBA macro to wait for...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.