Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
shell question ?
Hello,
With the Shell function of VBA how can I write the equivalent of : SubInAcl /output=result.txt /subddirectories c:\ And also I can I do to make "result.txt" be a variable (so I can loop this cmd on many folder without erase the previous result) I can only do that Dim RetVal RetVal = Shell("C:\WINDOWS\SubInAcl.exe", 1) But it's useless !!! Can someone help me ? Cheers Matthieu |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
shell question ?
I am not sure what the problem is about passing the parameters. Try:
shellline="C:\WINDOWS\SubInAcl.exe /output=* /subddirectories) shellline=replace(shellline,"*",yourfilename) RetVal = Shell(shellline, 1) "Mathew" wrote: Hello, With the Shell function of VBA how can I write the equivalent of : SubInAcl /output=result.txt /subddirectories c:\ And also I can I do to make "result.txt" be a variable (so I can loop this cmd on many folder without erase the previous result) I can only do that Dim RetVal RetVal = Shell("C:\WINDOWS\SubInAcl.exe", 1) But it's useless !!! Can someone help me ? Cheers Matthieu |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Shell | Excel Programming | |||
Shell and Command Prompt Question | Excel Programming | |||
VBE COM Add-in Shell | Excel Programming | |||
Shell to MSAccess | Excel Programming | |||
Shell | Excel Programming |