title: How to copy a file from local hard drive to a mapped drive with password using cmd?
body: <p>I am aware of the fact that this could be done more easily with copy and paste, but the point here is to use VBA to automate the process so some other people can just click a button and the file will be copied automatically. I have tried to use copy command under cmd but failed, as this does not invoke the password prompt windows so no way to access the hard drive. Is there any other way to tackle this issue? It does not matter if the user name and password cannot be embedded as part of the command. If the command can manage to pop up the window for user name and password entries that is also acceptable. Any suggestions? Thanks.</p>