I started out with the need to be able to launch a putty SSH window from Excel that had a list of hosts and/or IP addresses.
In Microsoft Excel
1) View/Toolbars Visual Basic
2) Click the Control Toolbox icon
3) Click on the Command Button icon and then click in your worksheet or drag the icon symbol.
4) Right click on the button and choose properties.
5) Change the name to PuttyButton
6) Change the Caption to “Launch Putty”
7) Double click on the button to bring up the Visual Basic Editor
Make the script look like the following (Make sure the paths are correct for you)
Private Sub PuttyButton_Click()
Shell “C:\Program Files\putty\putty.exe ” & ActiveCell, vbNormalFocus
End Sub
9) Go to file and choose close and return.
10) Unselect Control Toolbox and Unselect the Design Mode button.
11) Add an IP or hostname to a cell and Click on the Launch Putty Button.
If you have a different login then make the cell read “-l login 12.9.12.10″ and the button will still work.
