Epic way to connect to Linux server from Microsoft Excel.

32-bit: putty.exe (or by FTP) (signature)

64-bit: putty.exe (or by FTP) (signature)

Please keep the downloaded putty.exe under c:\ location.

purpose I have added only two ip address for connecting to Linux server as below:

Now we need to write sample macro so that it will call putty.exe upon double click event. For that Press “Alt+F11” within microsoft excel. Then new window will open as below :

 

Now Right click on Sheet1 (sheet in which you have all your ip details) and select View code option as below:

Now in the blank window on the right side paste below code, so that whenever you double click on ip column , putty.exe will be called with passing ip as a parameter.

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
    Shell "C:\putty.exe -ssh " & ActiveCell, 1
    Cancel = True
End Sub

in case your username is same for all your connection use below code so that you only need to type password in the putty window.

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
    Shell "C:\putty.exe -ssh -l root " & ActiveCell, 1
    Cancel = True
End Sub

In above we have used root as user for connecting automatically using putty.

4. Save the file with .xltm extension.

Now Press Ctrl+s for saving the file. Save this file as “Excel macro-Enabled Template” with “.xltm” extension.

5. Double click on IP column for connection with server.

Now you are almost done to connect to Linux server from Microsoft Excel. Just double click on the cell which has ip and putty will be called automatically passing IP as an parameter.

This How we double click on ip column to connect with server.