hi,

Have a problem that I have not been able to correct.

Attempting to create a shell to run

"C:\Program Files\Remote Control Viewer\RCViewer\isscntr.exe" -
a"comp_name" -c"Remote Control"
where comp_name is a string variable (i.e. LTDE562541 or PCDE845496
etc)

the quotes are needed

have been unable to create a string with the quotes, keep getting
"unexpected end"

am getting confusted with trying to get quotes within quotes

Help? Please

Thanks

stevenrec wrote:
have to "escape" it.In the "basic" languages, VB, VBA and vbscript, that
requires you to double the character. To get you started, look at this:

sCmd= """C:\Program Files\Remote Control Viewer\RCViewer\isscntr.exe"""
debug.print sCmd

When you run this in the VBA editor, you will see
"C:\Program Files\Remote Control Viewer\RCViewer\isscntr.exe"
appear in the Immediate window.

Now, the task is to concatenate the value contained in comp_name into your
sCmd variable:
sCmd=sCmd & " -a""" & comp_name & """'
debug.print sCmd

The last part should be easy for you so I will leave it for you to do.

Thanks

used your info and made it work

shelltxt = """C:\Program Files\Remote Control Viewer\RCViewer
\isscntr.exe"""
shelltxt = shelltxt & " -a""" & findit & """" & " -c""Remote
Control"""

Call Shell(shelltxt, 1)

there are too many quotes to count, hard to even read on screen

now know why I usually just use a .cmd file for most shell commands

thanks again

"stevenrec" <steven (AT) stevenrec (DOT) com> wrote

You may find this way to be more convenient/readable:

Const qt = """"

shelltxt = qt & "C:\Program Files\Remote Control
Viewer\RCViewer\isscntr.exe" & qt