Commands at the line prompt using Shell
 

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

Commands at the line prompt using Shell
 

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

Commands at the line prompt using Shell
 

W,

Oops. They're variables. Heh heh. <sg Make that:

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

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"Earl Kiosterud" wrote in message
...
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