Private Declare Function FindWindow Lib "user32" Alias "FindWindowA" (ByVal lpClassName As String, ByVal lpWindowName As String) As Long
Private Declare Function ShowWindow Lib "user32" (ByVal hwnd As Long, ByVal nCmdShow As Long) As Long

'Esta rutina la tome de un ejemplo del maestro "Hades,-"
Private Sub Focus(Cadena As String)
Dim Handle As Long
    Handle = FindWindow(vbNullString, Cadena) 'Buscamos la ventana
    If Handle <> 0 Then
        ShowWindow Handle, 1 'Mostramos la ventana
    End If
End Sub

Private Sub Command1_Click()
    Shell ("notepad.exe") 'Ejecutas el notepad
    Focus "Sin título - Bloc de notas" 'Le das focus
    SendKeys "mi nombre o..." 'Y le envias lo que querais
End Sub