ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Pass cell contents to external program as commandline option (https://www.excelbanter.com/excel-discussion-misc-queries/45438-pass-cell-contents-external-program-commandline-option.html)

Research freak

Pass cell contents to external program as commandline option
 
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?


Research freak

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.



All times are GMT +1. The time now is 11:51 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com