I use xcopy to copy Excel files from point A to point B. The issue I have is when someone has a file open and the batch file tries to copy it to point B. If I try to open the file from point B the file opens but gives me a notice that the user has a lock on the file. Is it possible to only copy those files not in use?
Thanks,
John