hide dos cmd window on execution... 1

[Webkins]

Good morning to all. I am using Access 2003 and VBA to unencrypt a local file. It is working very well but the DOS window appears during the unencryption process. I would like not to see this window during the transformation. Here is the code I am using which is working fine with the exception of seeing the DOS window:

dosCmd = "cipher /a /d /s:" & attachment_1
ReturnCode = Sh.Run(dosCmd, 1, True + vbHide)

Thank you and have a beautiful day.

 

[PHV]

Provided that Sh is an WshShell object:
ReturnCode = Sh.Run(dosCmd, 0, True)

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

 

[Webkins]

THAT WORKS PERFECT ! Thanks so much ! Curious as how this works if you have more information. Again, thank you and have a star !

 

[PHV]

Have a look here:

http://msdn.microsoft.com/en-us/site/d5fk67ky

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