Use an Excel Spreadsheet to Connect Through pcAnywhere

Like many IT departments you probably maintain a database or spreadsheet to inventory computers. Here is a quick way to use bring your spreadsheet and pcAnywhere together. This works with the full version of pcAnywhere and pcAnywhere that is installed with SMC 7

First create a macro in your spreadsheet. I named the macro PCA_Remote and assigned Ctrl + q as a shortcut key to this macro.

Next you will need to edit the macro and add the following code:

Sub PCA_Remote()
'
' PCA_Remote Macro
' pcAnywhere Remote Control
'
' Keyboard Shortcut: Ctrl+q
'
Dim vCell As String

' ****** What computer name to use. You may substitute ip addresses ******  
vCell = ActiveCell.Value

' ****** You may nee to change the path if you did not use the default installation path. ******
Shell ("C:\Program Files\Symantec\pcAnywhere\AWREM32.EXE C:\Documents and Settings\All Users\Application Data\Symantec\pcAnywhere\Remotes\Network, Cable, DSL.chf /C" & vCell)

End Sub

Now save your spreadsheet. Select a computer and the press the Ctrl+q shortcut key. You can add a button to your sheet and assign the macro to that button.