I have a need to create an excel spreadsheet that calls "vncviewer.exe"
from links, passing the server name to the program. The external
program is accessed as Z:\vncviewer.exe, and accepts a server in the
form of "Z:\vncviewer.exe servername" with a single space between
them. I can start the program using the insert hyperlink function,
which is useful, but not as automated as I would like. How would I
code a hyperlink to pass the name of the server (the text in the cell
with the hyperlink) to vncviewer as a commandline option?

I found an older post that does this almost exactly, using the shell
command. Does anyone have a preference? If so, why? Please help me
understand what the better solution is.