pass a variable into a 'shell' command

[hopelessliar]

Does anyone know if it is possible to do this?

What I am actually trying to do is choose a random name from an array and then pass that name into a shell command like this:

dim Names as Variant
varData = Array("name1", "name2", "name3")


shell "net send [randomnamehere] mymessage"


If anyone has a useful hint on how to go about this, I'd be grateful.

Thanks

 

[PHV]

Take a look at the Randomize instruction and the Rnd function.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[hopelessliar]

Thanks for the swift reply, but it's the passing the value into the shell command that I'm most concerned about rather than the random value...

 

[EBGreen]

Look at the help for the Shell function.

Shell(pathname[,windowstyle])

[red]"... isn't sanity really just a one trick pony anyway?! I mean, all you get is one trick, rational thinking, but when you are good and crazy, oooh, oooh, oooh, the sky is the limit!" - The Tick[/red]

 

[PHV]

Something like this ?
shell "net send " & randomnamehere & " mymessage"


Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[hopelessliar]

That's what I thought but doesn't seem to work

 

[EBGreen]

What does it do?

[red]"... isn't sanity really just a one trick pony anyway?! I mean, all you get is one trick, rational thinking, but when you are good and crazy, oooh, oooh, oooh, the sky is the limit!" - The Tick[/red]

 

[hopelessliar]

Ok it seems that I must have typed something wrongly, because now I have it working. For anyone who is interested, it works like this:

Dim name As String
Dim numb As Single

vardata = Array("name1", "name2", "name3", "name4")
Randomize
numb = Int((3 * Rnd) + 0)
name = vardata(numb)

Shell "net send " & name & " You will be making the tea today"