View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] james.wood@gistworld.com is offline
external usenet poster
 
Posts: 1
Default Managing errors in VBA

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