L
Legacy 87448
Guest
Hello. I work at a hospital where I have an excel spreadsheet of all inventory (computers/printers/etc). I use UltraVNC to remotely connect to my computer stations and troubleshoot. What I would like to have is a link or macro that would allow me to click the name of the computer I want to connect to in Excel and open up UltraVNC with the argument <computername>.
If you run a shortcut 'vnc.lnk' with a target "path\VNCviewer.exe <computername>" (without quotes or brackets), VNC will open and automatically attempt to connect to the computer with that name.
So I need to execute VNC.exe with a parameter to automatically input the workstations' name in the corresponding cell.
I've attempted a hyperlink which does work and seems like the easiest thing, however I get about 4 popups (warnings about macros, then viruses, then a popup asking where i want to 'move' the shortcut to, then where i want to 'copy' it to). If I cancel or ok all these VNC will popup and ask for a password.
I've also attempted a batch file which then runs the VNC shortcut. This also works, but the problem is that I have 150+ workstations and I don't want a separate shortcut and batch for each one. I want a single vnc.exe which I can place the computer name into.
I hope this makes sense. Thanks so much for any help! I'm not great with VB but I'm trying to learn. I'm willing to try whatever I need.
If you run a shortcut 'vnc.lnk' with a target "path\VNCviewer.exe <computername>" (without quotes or brackets), VNC will open and automatically attempt to connect to the computer with that name.
So I need to execute VNC.exe with a parameter to automatically input the workstations' name in the corresponding cell.
I've attempted a hyperlink which does work and seems like the easiest thing, however I get about 4 popups (warnings about macros, then viruses, then a popup asking where i want to 'move' the shortcut to, then where i want to 'copy' it to). If I cancel or ok all these VNC will popup and ask for a password.
I've also attempted a batch file which then runs the VNC shortcut. This also works, but the problem is that I have 150+ workstations and I don't want a separate shortcut and batch for each one. I want a single vnc.exe which I can place the computer name into.
I hope this makes sense. Thanks so much for any help! I'm not great with VB but I'm trying to learn. I'm willing to try whatever I need.