Calling in data from a selected cell

A

Alan

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA-Table Word 2019 - Move a selected text, from a cell to the adjacent cell to its right, by pressing the ENTER key 0
Change a great number of words in word files, with a macro as short as possible. 5
Word macro that can call cells out of Excel for a find and replace 0
Applying a style depending on currently selected cell? 2
Code to add comments to selected cells within a selected range 30
Open another program (VNC Viewer) and insert an address 7
Creating a Chart on form from selected data in query. 0
Drop down list control value in vba 2

Top