Hi Guys,
Would you please help to find a script I want to open a hyperlink by selecting a cell value first, then run the script. I have almost the same script which is working perfectly but this one is by selecting the cell value and run the RDP:
==============
Sub rdpnow()
' Get currently selected server name
serverName = Selection.Value
If (serverName <> "") Then
RDPWindow = Shell("C:\windows\system32\mstsc.exe /v:" & serverName & " /admin", 1)
End If
End Sub
=========
This time I want to select the cell value and open a URL. Let say on Cell A1=192.168.1.1. The output should be https://192.168.1.1:4343. Can you please help? Thanks.
Would you please help to find a script I want to open a hyperlink by selecting a cell value first, then run the script. I have almost the same script which is working perfectly but this one is by selecting the cell value and run the RDP:
==============
Sub rdpnow()
' Get currently selected server name
serverName = Selection.Value
If (serverName <> "") Then
RDPWindow = Shell("C:\windows\system32\mstsc.exe /v:" & serverName & " /admin", 1)
End If
End Sub
=========
This time I want to select the cell value and open a URL. Let say on Cell A1=192.168.1.1. The output should be https://192.168.1.1:4343. Can you please help? Thanks.