Shell Syntax needed...

[bengalliboy]

I am trying to run a windows program using Shell command.

The commands that work from command prompt is as follows:

Bteq <Script.scr> Log.txt

I tried the following code:
Shell &quot;Bteq <Script.scr> Log.txt&quot;

But only the Bteq program is open but I guess the parameter is not passed. The general command for this should be:
Bteq <ScriptName
I tried by reference or By Val using function but did not get much...
Any Suggestion?
TIA

 

[vbMax]

It looks like your syntax should work. If you are
still having problems, try placing your command in a
batch file. Then execute the batch file with the
Shell command.

- vbMax