Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Managing errors in VBA
sounds like something you would incorporate in your code in terms of addin
code to see if the database can be updated before trying to update it. Without knowing how you are trying to update the database, it would be hard to provide specifics. If you want to find if a workbook on a shared drive is opened by another user you could use http://support.microsoft.com?kbid=138621 XL: Macro Code to Check Whether a File Is Already Open http://support.microsoft.com?kbid=291295 XL2002: Macro Code to Check Whether a File Is Already Open http://support.microsoft.com?kbid=213383 XL2000: Macro Code to Check Whether a File Is Already Open -- Regards, Tom Ogilvy " wrote: 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Managing errors in VBA
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Throwing Circular Errors When No Errors Exist | Excel Worksheet Functions | |||
Managing Printing | Excel Programming | |||
Managing bad data | Excel Discussion (Misc queries) | |||
Managing Add-Ins | Excel Programming | |||
Unresolved Errors in IF Statements - Errors do not show in results | Excel Worksheet Functions |