I know there are simple commands to login to remote machine through VBA i.e. by specifying User@hostname
and -pw
option to provide the password in Wshell.Run
function where Wshell
is CreateObject("WScript.Shell")
.
However I need to use private key file (specified under Connection/SSH/Auth option in PuTTY) while logging in through Excel-VBA macro. Is there a way to do it?
I need it because I am using admin account on the second form of my VBA code (First form is using user's own account) and hence cannot provide the password textbox on the second form. Hence the only secure solution is to use SSH login through public and private key.
Thanks in advance!
PuTTY uses its own file format for SSH keys. The keys are stored in . ppk files.
Use the -i
switch to specify the private key.
putty.exe username@example.com -i mykey.ppk
See PuTTY command line documentation.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With