Open another program (VNC Viewer) and insert an address

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want some VBA code to activate a program called VNCViewer then paste in an
address and activate.
I have been able to open the program using the following code:

Private Sub cbVNC_Click()

Dim Program As String
Dim TaskID As Double
On Error Resume Next

Program = "C:\Program Files\RealVNC\VNC4\vncviewer.exe"
TaskID = Shell(Program, 1)

End Sub

Which opens the program no problem. Any ideas how I can pass an address to
it and get it to look it up? The action of this would be to paste in the data
then press return

Thanks
 
Hello
Not sure if this works with your VNC version but you may try from the
commandline eg:

Dim ipAddress
ipAddress = "123.4.5.6"
Program = "C:\Program Files\RealVNC\VNC4\vncviewer.exe" & " server:" &
ipAddress

NB: this works with UltraVNCViewer

HTH
Cordially
Pascal
 
Thanks papou

Looks like it's on the right track but not quite there. I get the error
message
"getaddrinfo: no such host is known. (11001)"
I'm using an IP address I know works, although of course I am asked to enter
a password - could that be the problem?

Thanks
osm
 
As I said I can hardly tell whether this works with your VNC version.
Have you tried from the Windows Start/Run menu?

Cordially
Pascal
 
Hi
No I haven't. Not quite sure what you mean!

I have a folder of VNC link files. If I could simply activate one of these
from inside the code it would do the job and get around any password issues...

Regards
OSM
 
Try and execute the program line from your code into the "Run" window
available from the Windows "Start" button.
eg:
From the Windows menu (that is NOT in Excel):
Start
Run
"C:\Program Files\RealVNC\VNC4\vncviewer.exe" "server:123.4.5.6"
Ok

And see if this works.

HTH
Cordially
Pascal
 
Well hopefully somebody else will come up with something?
If not then why not change your version to UltraVNC?
;-)

Cordially
Pascal
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Closing Process minimizes my application 3
Kill a process - Could someone check this code for me 2
Exe file search and insertion? 7
Problem with my Else statement 3
XP Problems with SendKeys - dialing a number in an Excel cell 1
Dialer.exe - I am actually trying to get dialer.exe to dial Excel cell phone numbers. I am using Exc 1
Sendkeys to external application not working 1
Open different form based on combo box selection 2

Back
Top