View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
one sick moo[_2_] one sick moo[_2_] is offline
external usenet poster
 
Posts: 3
Default Open another program (VNC Viewer) and insert an address

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

"papou" wrote:

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

"one sick moo" a écrit dans le
message de news: ...
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

"papou" wrote:

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

"one sick moo" <one sick
a écrit dans le
message de news:
...
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