VBA Read from Excel Launch App to Connect using SSH or SCP

[kdwdillson]

Please help. Trying to write VBA (beginner). Not working. I have 2 worksheets; servers and password.
I want vba code to launch either putty (SSH) or winscp (SCP) when clicking on either SSH or SCP to right of FQDN. The launched application should connect to that FQDN. In example, if I click on SSH to right of server2.acme.com, it should launch a putty session, connecting to server2.acme.com. Or is I click on SCP to right of server2.acme.com it should launch a winscp session, connecting to server2.acme.com. apps: c:\temp\winscp\winscp.exe & c:\temp\puty\putty.exe.

Please provide vba source code how this will work. Thank you!

I struggled writing vba to read userID&password and passing credential to app.

[TABLE="width: 500, align: left"]
<tbody>[TR]
[TD]Env[/TD]
[TD]App[/TD]
[TD]Alias[/TD]
[TD]FQDN[/TD]
[TD]Protocol[/TD]
[TD]Protocol[/TD]
[/TR]
[TR]
[TD]Prod[/TD]
[TD]w1[/TD]
[TD]p[/TD]
[TD]server1.acme.com[/TD]
[TD]ssh[/TD]
[TD]scp[/TD]
[/TR]
[TR]
[TD]PreProd[/TD]
[TD]x1[/TD]
[TD]pp[/TD]
[TD]server2.acme.com[/TD]
[TD]ssh[/TD]
[TD]scp[/TD]
[/TR]
[TR]
[TD]Test[/TD]
[TD]y1[/TD]
[TD]t[/TD]
[TD]server3.acme.com[/TD]
[TD]ssh[/TD]
[TD]scp[/TD]
[/TR]
[TR]
[TD]Dev[/TD]
[TD]z1[/TD]
[TD]d[/TD]
[TD]server4.acme.com[/TD]
[TD]ssh[/TD]
[TD]scp[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]