(Excel) SSH Commands to Cisco Switch

Demonstrates how to establish an SSH session with a Cisco switch (or something similar) and send commands in a device console session.

Download Excel Class Modules Chilkat Excel Class Modules

' This example assumes the Chilkat API to have been previously unlocked.
' See Global Unlock Sample for sample code.

Dim ssh As Chilkat.Ssh
Set ssh = Chilkat.NewSsh


success = ssh.Connect("172.16.16.100",22)
If (success <> True) Then
    Debug.Print ssh.LastErrorText
    Exit Sub
End If

' Authenticate using login/password:
success = ssh.AuthenticatePw("myLogin","myPassword")
If (success <> True) Then
    Debug.Print ssh.LastErrorText
    Exit Sub
End If

' Start a shell session.

channelNum = ssh.QuickShell()
If (channelNum < 0) Then
    Debug.Print ssh.LastErrorText
    Exit Sub
End If

' If the CISCO switch returns a prompt with "#", then read until we get the prompt.
' (It's not actually required that we do this, but it helps to know that all is OK at this point..)
success = ssh.ChannelReceiveUntilMatch(channelNum,"#","utf-8",True)
If (success <> True) Then
    Debug.Print ssh.LastErrorText
    Exit Sub
End If

' Show what we received so far:
Debug.Print ssh.GetReceivedText(channelNum,"utf-8")

' Send a "show clock" command.
success = ssh.ChannelSendString(channelNum,"show clock" & vbLf,"utf-8")

' Read the output to the next interactive prompt.
success = ssh.ChannelReceiveUntilMatch(channelNum,"#","utf-8",True)
If (success <> True) Then
    Debug.Print ssh.LastErrorText
    Exit Sub
End If

Debug.Print ssh.GetReceivedText(channelNum,"utf-8")

' Send another command and get the output, and so on...
success = ssh.ChannelSendString(channelNum,"some other command" & vbLf,"utf-8")
success = ssh.ChannelReceiveUntilMatch(channelNum,"#","utf-8",True)
If (success <> True) Then
    Debug.Print ssh.LastErrorText
    Exit Sub
End If

Debug.Print ssh.GetReceivedText(channelNum,"utf-8")

ssh.Disconnect