Dear All,

Here's a quick one:

I was trying to pass parameters to this script file in VBA code :

Shell "\\lvamfs01\advent\Axys\Axys32.Exe script testappend3.scr batchpassvalue -exit"

where the batchpassvalue variable has the value "mts" stored in it; but what happens is that when the code is executed instead of the value stored in batchpassvalue getting passed , it itself gets passed as the value. I have tried combinations with batchpassvalue like

%batchpassvalue%
&batchpassvalue&

but the whole thing gets passed as the value itself.

Is there a way through which we can pass the value stored in batchpassvalue or any other variable, instead of it itself getting passed ?

Cheers
Goels

Dear All,

I found out the way in which one can acheive the desired functionality. Posting the answer here as it might be of some help to any viewer:

Shell ("\\lvamfs01\advent\Axys\Axys32.Exe script testappend3.scr " & batchpassvalue & " -exit")

It was just a matter of getting the right syntax in place; which believe me as one new to programming i am finding notoriously difficult.

Cheers
Goels