W,

RetVal = Shell("c:\SaleItems\SaveDataOut.bat Var1 Var2", 1)
--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"cogent" wrote in message
...
Hello

Presently I invoke a batch file to initate the desired commands in the DOS
Shell:

RetVal = Shell("c:\SaleItems\SaveDataOut.bat", 1)

but the macro has matured such that I would prefer to run line commands at
the prompt using VBA (which would allow me to put in variables) instead of
running the static batch file.

Is there a way to do that?

Please help.

W