Calling in data from a selected cell
 

Can someone show me how I can replace the text 'ws66' with the contents of
the active cell in the macro below? I want to be able to list all the
workstations in Col A and have the user select the cell of the workstation
they want to connect to and have the text of that cell be fed into the
macro.


Sub RunVNC()

Shell ("C:\Program Files\Hyena\VNC4\vncviewer.exe ws66")

End Sub

TIA, Alan

Calling in data from a selected cell
 

Shell ("C:\Program Files\Hyena\VNC4\vncviewer.exe " & ActiveCell.Value)
--
- K Dales


"Alan" wrote:

Can someone show me how I can replace the text 'ws66' with the contents of
the active cell in the macro below? I want to be able to list all the
workstations in Col A and have the user select the cell of the workstation
they want to connect to and have the text of that cell be fed into the
macro.


Sub RunVNC()

Shell ("C:\Program Files\Hyena\VNC4\vncviewer.exe ws66")

End Sub

TIA, Alan