M
Mad Scientist Jr
I have a batch file I would like to execute from an Excel macro, and
have the output be piped to a file. For this test I created a file
"dir.bat" in the same folder as "Book1.xls", the file contains one
line, "dir /b /o"
dir.bat > dir.txt
it successfully saves the directory listing to "dir.txt".
However it doesn't seem to be working from the Excel macro:
Sub ShellTest()
Shell ThisWorkbook.Path & "\dir.bat > dir.txt"
End Sub
I get no error messages, and dir.txt gets created, but it is empty.
Can anyone see anything wrong?
Much appreciated...
have the output be piped to a file. For this test I created a file
"dir.bat" in the same folder as "Book1.xls", the file contains one
line, "dir /b /o"
From the command prompt, if I run it like so
dir.bat > dir.txt
it successfully saves the directory listing to "dir.txt".
However it doesn't seem to be working from the Excel macro:
Sub ShellTest()
Shell ThisWorkbook.Path & "\dir.bat > dir.txt"
End Sub
I get no error messages, and dir.txt gets created, but it is empty.
Can anyone see anything wrong?
Much appreciated...