| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
getting vba shell command to execute batch and save output to a file
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" 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... |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
getting vba shell command to execute batch and save output to a fi
why not change the line in the bat file to
"dir /b /o dir.txt" -- Regards, Tom Ogilvy "Mad Scientist Jr" wrote: 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" 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... |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
getting vba shell command to execute batch and save output to a fi
"Why didn't I think of that?!"
Sounds like a good idea, let me try that, thanks! Tom Ogilvy wrote: why not change the line in the bat file to "dir /b /o dir.txt" -- Regards, Tom Ogilvy "Mad Scientist Jr" wrote: 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" 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... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Shell Function - Execute DOS Command | Excel Programming | |||
| Shell command and exe file conundrum | Excel Programming | |||
| Batch file in Shell Function | Excel Programming | |||
| Execute a batch file from inside Excel | Excel Programming | |||
| Copying a file with VBA (or with a SHELL command) | Excel Programming | |||
Linear Mode
