Saving the output of a dos command throung Excel VBA 2

[LSIGuy]

Can someone please give me a pointer on how to save the output of a shell command issued through Excel VBA to a dump file? I need to be able to analyze the return to continue my program. Thanks.

 

[ETID]

Add a the redirect output symbol to your shell string



I.E.


shell("dir c:\temp >c:\temp\my_temp.txt&quot

you can then open the my_temp.txt in notepad or msdos edit, word, etc

or open it from within vba...

open ("c:\temp\my_temp.txt&quot for input as #1

 

[ETID]

Ooops my bad

You'll have to write the redirect string to a batch file,


then shell the batch file


example:

Sub write_batch()
Open ("c:\temp\my_temp.bat&quot For Output As #1
Print #1, "dir c:\temp >c:\temp\my_temp2.txt"
Close
End Sub
---------------------------
Sub run_bat()
Shell ("c:\temp\my_temp.bat&quot
End Sub

 

[rmikesmith]

Etid,

I seem to recall that you could use something like the following to carry out a DOS command directly from the SHELL command, w/o resorting to batch files:

Shell("command.com /C dir c:\temp >c:\temp\myTemp.txt")

Also, I have successfully used the following on my new Win 2000 Pro system:

Shell ("cmd.exe /C dir c:\temp >c:\temp\my_temp.txt")

Comments?

Regards,
Mike

 

[ETID]

This worked for me on win 2k ...


Shell ("cmd.exe /C dir c:\temp >c:\temp\my_temp.txt&quot


Thanks and a star, Mike