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.

Env	App	Alias	FQDN	Protocol	Protocol
Prod	w1	p	server1.acme.com	ssh	scp
PreProd	x1	pp	server2.acme.com	ssh	scp
Test	y1	t	server3.acme.com	ssh	scp
Dev	z1	d	server4.acme.com	ssh	scp

<tbody>
</tbody>