View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Harlan Grove[_2_] Harlan Grove[_2_] is offline
external usenet poster
 
Posts: 1,231
Default Executing a bat file from Excel

"Mr BT" wrote...
empty echos?


Console commands that produce only newlines, which when redirected to
the batch file via a pipeline would be processed by the batch file in
exactly the same way as pressing [Enter].

The point is you don't need to use SendKeys from Excel to the console
window. The command that launches the batch file can simulate pressing
[Enter] twice during batch file execution as long as you want fully
NONINTERACTIVE batch file execution.

Could you explain how I could include this in the vb script?


See my previous post.