I am in the process of building an excel template which links
automatically to an excel database. A macro is involved in transferring
some of the data to the database. 15 different people will have a
template and it is possible that 2 of them may try to update the
database at exactly the same time. This would result in a macro error.
Is it possible that instead of showing the error and taking the user
into VBA, a flag could show up in the template telling the user to try
again in 5 minutes?
Any help would be gratefully received!
James
Bookmarks