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
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 ?