Help launching VNC through Excel

Guest2

Guest2

Guest2

Soldato
Joined
6 May 2009
Posts
20,361
I have an excel sheet with all our users. I would like to link VNC to this so i can click connect on a user and VNC is fired up

I have this code in excel

=HYPERLINK("C:\Program Files\RealVNC\VNC4\vncviewer.exe"&E47,"Connect")

In E47 I have the computer name '\\lds0013\'

When I press connect it says "cannot open the specified file"

What is the correct code that would fire up vnc with the correct ip address/computer name?


Thanks
 
When i direct it to 192.168.10.91 thats in a cell, it says the same thing "cannot open the specified file"

So i have

=HYPERLINK("C:\Program Files\RealVNC\VNC4\vncviewer.exe"&D29,"Connect")

and in D29 have - 192.168.10.91
 
derkaderka - where does all that code go in? Saved as a .vnc file or in excel? I am trying to get it working through excel.

MPKeates - I tried with a space and changed \\lds0013\ to just lds0013. However it still says the same thing
 
Just realised some of the passwords are different and are also on the excel sheet i am using.

The following code works fine and launches VNC but it obviously isnt liking the part where it gets the ip address (or computer name)

=HYPERLINK("C:\Program Files\RealVNC\VNC4\vncviewer.exe")

Every time i open the excel sheet i would have to trust the macro. Think it would be easier to just do what i do now and open the sheet (network users) then find the user with their IP and password, fire up VNC and get in.

I just though it might be quite easy to have a link to open vnc for a particular user within the same sheet
 
You must log in or register to reply here.
Back
Top Bottom