Commands at the line prompt using Shell

C

cogent

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
 
E

Earl Kiosterud

W,

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

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Running a Batch file from VBA 6
Launch program using Shell function 3
Global/Public/Universal variables 8
send parameters to a batch file with the shell command 6
Shell or shellexecute 1
Using a "SHELL" Command 10
running two separate commands in same Shell 3
Simple Shell Commands 4

Top