Hello All,
After beating my head against the wall with this, I'm finally reaching out for help.  I created a command button to copy files from one location to another when clicked.  I've looked all over for the solution, which isn't readily apparent but I'm coming up dry.  Here is my code;
____________________________________________________________

Private Sub Command142_Click()
Shell "Net Use S: /DELETE", vbHide
Shell "Net Use S: \\WIN-SERVER-001\Attachments", vbHide
Shell "Copy S:\*.* C:\Users\%USERNAME%\Documents\", vbHide
Shell "Net Use S: /DELETE", vbHide
MsgBox "File Copied Successfully!"
End Sub
___________________________________________________________

When I click the button I get a runtime error that points to the following line;
___________________________________________________________
Shell "Copy S:\*.* C:\Users\%USERNAME%\Documents\", vbHide
__________________________________________________________
The runtime error says "File not found"


Any help would be appreciated.  Thanks.