Excel VBA "Shell script.vbs > textfile.txt" not working 1

[Divercem]

I have the following code that works directly from a command prompt, but doesn't work from Excel VBA:

retVal = Shell("cscript C:\Scripts\Exchange\Mailbox_Sizes_Info.vbs > C:\Scripts\Exchange\Mailbox_Sizes_Info.txt")

if I remove the redirected output the script runs in the command window, but I don't know how to capture it other than redirecting to a file.

Any help is definitely appreciated. )

 

[PHV]

retVal = Shell("[!]cmd /c [/!]cscript C:\Scripts\Exchange\Mailbox_Sizes_Info.vbs > C:\Scripts\Exchange\Mailbox_Sizes_Info.txt")

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[Divercem]

That did it! That's all it took? I've been banging on this snippet of code for a couple of days and didn't find the cmd /c comment anywhere.

Thanks so much!!!