View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
cogent cogent is offline
external usenet poster
 
Posts: 32
Default 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