SendKey Syntax

[Wgimblet]

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

 

[combo]

Sub test2123()
 Dim MtrId As String
    MtrId = ActiveCell.Text
    AppActivate "Test.txt - Notepad"[blue], True[/blue]
    SendKeys MtrId, True
End Sub

combo

 

[Wgimblet]

Thanks for the help.

 

[Wgimblet]

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.