View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
K Dales[_2_] K Dales[_2_] is offline
external usenet poster
 
Posts: 1,163
Default 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