I'm using VB in an Excel program to copy data from one spreadsheet and paste it to another. My problem is the spreadsheet I want to paste to is located in a shared file so more than one user may try to access it at once. When this happens the user gets a message: "File Reservation, this file is currently being used by 'name'." There are three buttons: Cancel, Notify, and Read Only. I want to write code in VB to capture this error and override it so that I can eliminate the Read Only and notify options and have a Retry (so that the user can't open the file until it has been closed and a Cancel option. When these users choose read only they end up copying this file over and over in the shared drive, making my job a nightmare to consolidate them all. Is there a way to do this? I've looked through several VB and Excel books and cannot figure it out. Thanks!
