Simple macro in Excel to open a Remote Desktop Connection to the server name or IP address in a cell. The idea here is the spreadsheet contains all the names and IP addresses of each server. Set the macro to run as shortcut with a key combination so the RDC connection will open up directly.
Dim RetVal As Variant
prg = “C:\windows\system32\mstsc.exe /v:” & ActiveCell.Value
RetVal = Shell(prg, 1)