Link to home
Start Free TrialLog in
Avatar of hej613
hej613

asked on

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
Avatar of Nick Denny
Nick Denny
Flag of United Kingdom of Great Britain and Northern Ireland image

Open a VNC instance to the IP you want.
"Save connection as" whatever you want.
Hyperlink to this in excel.

ASKER CERTIFIED SOLUTION
Avatar of papimichel
papimichel

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of hej613
hej613

ASKER

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
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.