I currenlty have 175 sites of network addresses (1 site per sheet). Each sheet has the IP address I need to connect to in cell B3.

I have a command button that opens Remote Desktop to connect to this address, but I have had to type the address manually into the VBA for each sheet.

I am trying to pass the address value in cell B3 to the VBA for the command button.
(w.x.y.z is the IP address of the target system)

I have tried setting a variable to the contents of cell B3, but can not pass it to mstsc.exe command line

Thnaks in advance for assistance with this

ex:

Private Sub CommandButton1_Click()
Dim RetVal

' Run Remote Desktop.
RetVal = Shell("c:\windows\system32\mstsc.exe /v:w.x.y.z", 1)
End Sub


EggHeadCafe.com - .NET Developer Portal of Choice
http://www.eggheadcafe.com