Passing a String's Value using the Shell Command

[solidjp]

I am using the shell command to pass a variable to another vb program like this:

Shell "C:\Folder\App.exe sName"

sName holds a value like "Bob". But when I call the second app with sName attached to the end of it, the Command only sees sName as sName and not the value "Bob" that is assigned to it. So how do I send a string's value to the shelled app?

Thanks...

 

[TomKane]

Instead of:

Shell "C:\Folder\App.exe sName"

Try using:

Shell "C:\Folder\App.exe " & sName

I think the sName is being treated as a literal because it is within your quotes.

Hope this helps

 

[solidjp]

Thanks again TomKane and I am an idiot. I can't believe I've had that big of a brain fart for the past 4 days to not be able to figure that out. Anyway, thanks.

 

[kel1981b]

Not sure but I think it should be like this

Shell("C:\Folder\" & App.exe & " " & sName)