View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
AA2e72E AA2e72E is offline
external usenet poster
 
Posts: 400
Default 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