title: Open PuTTY and run shell script on server
body: <p>I want to open Putty from local machine, automatically login to the server, and run shell script on the same session of putty using Excel VBA Script.
  The code below works fine to open putty.</p>
  
  <pre><code>Sub open_putty()
      Dim UserName 'assign user name
      Dim Passwrd 'assign password
      Dim TaskID As Long
      pc1 = "C:\Users\Desktop\putty.exe -ssh " &amp; UserName &amp; "@servernamee -pw " &amp; Passwrd
      TaskID = Shell(pc1, 1)
  End Sub 
  </code></pre>
  
  <p>However, I'm not able to run the shell script test.sh on the same session.  The script is in the default location after login.
  How can I run the shell script on the server using Excel VBA. </p>