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\vnc viewer.exe $A$
It's been so long since I did anything like this I would certainly appreciate any help.
Thanks
hej613
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\vnc
It's been so long since I did anything like this I would certainly appreciate any help.
Thanks
hej613
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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
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.
If you change the data the hyperlink should remain there.
"Save connection as" whatever you want.
Hyperlink to this in excel.