Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Multi-user dilemma.
I have a work macroo that is very simple. When a user enters a ten digi number, it does a find in the range of G100:G65000. It has thre responses : 1 not a ten digit number, 2 found (no action), 3 The te digit number is added to the next G cell, and is available for the nex find (re-run of the macro). In an attempt to go multi-user it was apparent that the users where i contention for the same cells at the same time. Is there a method or code that would allow for one to take precedence and the other to append to the applied changes, or am I looking at thi all wrong? Thank yo -- GC ----------------------------------------------------------------------- GCF's Profile: http://www.excelforum.com/member.php...nfo&userid=412 View this thread: http://www.excelforum.com/showthread.php?threadid=26844 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Multi-user dilemma.
Hi
Multiuser environment and 65k + data records is what databases do very well. You shouldn't use a spreadsheet program for this. HTH. Best wishes Harald "GCF" skrev i melding ... I have a work macroo that is very simple. When a user enters a ten digit number, it does a find in the range of G100:G65000. It has three responses : 1 not a ten digit number, 2 found (no action), 3 The ten digit number is added to the next G cell, and is available for the next find (re-run of the macro). In an attempt to go multi-user it was apparent that the users where in contention for the same cells at the same time. Is there a method or code that would allow for one to take precedence, and the other to append to the applied changes, or am I looking at this all wrong? Thank you -- GCF ------------------------------------------------------------------------ GCF's Profile: http://www.excelforum.com/member.php...fo&userid=4124 View this thread: http://www.excelforum.com/showthread...hreadid=268449 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multi user | Excel Discussion (Misc queries) | |||
Multi-user | Excel Discussion (Misc queries) | |||
Multi-User Passwords | Excel Discussion (Misc queries) | |||
multi user | Excel Discussion (Misc queries) | |||
Multi user | Excel Discussion (Misc queries) |