Capture output value from a shell command in VBA ?

Question

Found this function http://www.cpearson.com/excel/ShellAndWait.aspx

But would need also to capture output from the shell output. Any code suggestion ?

Answer 1

You could always redirect the shell output to a file, then read the output from the file.

Answer 2

You can CreateProcess the application redirecting its StdOut to a pipe, then read that pipe directly; http://pastebin.com/CszKUpNS

dim resp as string 
resp = redirect("cmd","/c dir")
resp = redirect("ipconfig","")