Excel Function that will execute a VNC connection

Hi Yall!
This is exactly what the title indicates. I want to add a function that will VNC to a users IP address. I have a completed spread sheet in Excel that stores PC data on our network. I do not want to go outside the program to VNC into the unit.
Can I do that? I want to right click on the IP address and vnc to it.
This is the location of my VNC program.

%ProgramFiles%\realVNC\vncviewer.exe $A$

It's been so long since I did anything like this I would certainly appreciate any help.
Thanks
hej613
LVL 1
hej613Asked:
Who is Participating?
 
papimichelCommented:

open excel , press Alt+F11
Paste this code:

Public Sub mmm()
    Shell "C:\Program Files\RealVNC\VNC4\vncviewer.exe " & ActiveCell.Value
End Sub

'Change the path to your VNC path.
then close the Microsoft visual basic window and press Alt+F8.

locate the line mmm and press the Options button. Now assign a shortcut key for this macro to run (for example Ctrl+V).

now when you click with your mouse oer the one of the ip's and press Ctrl+V it'll automatically run the VNC Viewer with the ip parameter we passsed it.

hope it'll all go fine..
yours, Michel
0
 
Nick DennyCommented:
Open a VNC instance to the IP you want.
"Save connection as" whatever you want.
Hyperlink to this in excel.

0
 
hej613Author Commented:
Seriousnick, I thought of that but it would it work if I changed the data in the field?

Papimichel, I will try that as soon as I get back to work. Sounds good I will let you both know which one works.

Thanks again, I have learned so much from all of you at EE.
hej613
0
 
Nick DennyCommented:
So long as the hyperlink points to the VNC shortcut, you can put whatever data you like in the cell.
If you change the data the hyperlink should remain there.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.