ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   My solution (https://www.excelbanter.com/excel-discussion-misc-queries/138583-my-solution.html)

Research freak

My solution
 
I created command buttons for each server, and used the following VBA
code with them:

Private Sub CommandButton<servername_Click()
Shell ("Z:\vncviewer.exe <servername")
End Sub

This runs the program and passes the servername. I did not look into
picking the servername from a list, but I think that would be
relatively trivial to do as well.

Randy



All times are GMT +1. The time now is 12:27 PM.

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