Hello,
Okay I give up! How do we keep the black DOS command prompt window from coming up while using the shell command in VBA?
The code below works fabulously except for the DOS window coming up every time the shell command gets executed. I read somewhere, (by which I can't find that site anymore 

), that removing the "K" from the shell command below should suppress the DOS box.... but I tried it and the DOS box still keeps coming up LOL!!!
Here's the my code:
Sub CopyingExportFileToHeaderFile()
Call Shell("""cmd"" /K copy " & _
MyPath & " " & "C:\CubeDir\User.h", vbNormalFocus)
End Sub
Any help is appreciated
Thanks
rn
Bookmarks