Need Shell to open program

G

Guest

I have a simple VB script that looks @ an IP list and when I double click on a cell it opens a telnet session using that cells IP. I need it to open the telnet session to the screen, but all it does now is open to the toolbar. What have I missed
Thanks in advance

Script is below

Private Sub Worksheet_BeforeDoubleClick(ByVal
Target As Range, Cancel As Boolean

Shell "C:\WINNT\system32\telnet.exe " & Target.Valu

End Sub
 
H

Harlan Grove

I have a simple VB script that looks @ an IP list and when I double click
on a cell it opens a telnet session using that cells IP. I need it to open
the telnet session to the screen, but all it does now is open to the toolbar.
What have I missed?

The Shell function takes a second argument. Read the entry for the Shell
function in online help to see what you need to use as the second argument.
 

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

Top