Excel VBA SSH SCP Help

[kdwdillson]

Have workbook with 2 worksheets. worksheet 1 has server info & worksheet 2 has different user ID & passwords. Seeking VBA code to make this happen, please. Thank you!

using putty & winscp: c:\temp\putty\putty.exe & c:\temp\winscp\winscp.exe

Need excel to launch either putty or winscp session (ssh or scp) when clicking on either ssh or scp. When click on either ssh or scp, it should use user ID & password from worksheet 2. Lets say password is Test123 and connect to corresponding server.
See table as guide.

[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD]Env[/TD]
[TD]Server[/TD]
[TD]Protocol[/TD]
[TD]Protocol[/TD]
[/TR]
[TR]
[TD]Prod[/TD]
[TD]server1.acme.com[/TD]
[TD]ssh[/TD]
[TD]scp[/TD]
[/TR]
[TR]
[TD]Test[/TD]
[TD]server2.acme.com[/TD]
[TD]ssh[/TD]
[TD]scp[/TD]
[/TR]
[TR]
[TD]Dev[/TD]
[TD]server3.acme.com[/TD]
[TD]ssh[/TD]
[TD]scp[/TD]
[/TR]
</tbody>[/TABLE]

 

[kdwdillson]

let's say a user id is user1, user2...