Ok well I've found some info, but still need help.

Code:
 Dim WindowName As String
        Dim Window As Long
        WindowName = "Untitled - Notepad"
        Window = FindWindow(vbNullString, WindowName)
        AppActivate(WindowName)
This code works great other than the fact that it doesn't restore the window if it's minimized. How can I have it restore the minimized window IF IT'S minimized.