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

"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

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

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

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

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



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