Specifying private key on PuTTY command-line

ssh command-line putty private-key
Sumit picture Sumit · Jun 3, 2016 · Viewed 22.8k times · Source

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!

Answer

Martin Prikryl picture Martin Prikryl · Jun 3, 2016

Use the -i switch to specify the private key.

putty.exe [email protected] -i mykey.ppk

See PuTTY command line documentation.

Related questions

SSH SCP Local file to Remote in Terminal Mac Os X

I am attempting to copy a local file 'magento.tar.gz' from my local machine to a remote server using SSH through a VPN. This is connecting to the Virtual Machine's Internal IP which I've used as xx.x.x.…

Read More
Execute ssh with password authentication via windows command prompt

I need to execute ssh from windows command line by providing password in a non interactive manner. I could implement the key based authentication and able to execute the ssh commands just like ssh <user>@<host> &…

Read More
Git says "Warning: Permanently added to the list of known hosts"

Every time I use git to interact with a remote, such as when pulling or pushing, I am shown the following message: Warning: Permanently added '...' (RSA) to the list of known hosts. How can I prevent this annoying …

Read More