LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default Possible for users to open file at the same time?

In response to your other post, I provided a method to get beyond a second.
The probability that any two people would get the same number would be
extremely small.

--
Regards,
Tom Ogilvy


"quartz" wrote in message
...
I am using Office 2003 on Windows XP.

Scenario: I have an Excel file uploaded into an Outlook folder. When users
open this file it automatically generates a form number on-open that uses

the
date and time down to the second. All form numbers must be unique, but NOT
necessarily in sequence.

Question: Given the scenario above, is it possible for two or more users

to
open this file at precisely the same moment and receive the same form

number?
Or is that impossible? Would one or all get an error? Or is there some way
--- code wise --- to prevent that from happening? Remember, this is in an
Outlook folder which allows users to open a copy of the file - but not

change
the original...

Thanks much for your assistance.



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Open a file by multiple users Scott Excel Discussion (Misc queries) 4 July 26th 09 07:15 PM
When i open excel file it takes time to open Muraliraj Menon Excel Discussion (Misc queries) 1 May 23rd 07 12:50 PM
2 users open same file and both can edit/change the file RANDY Excel Discussion (Misc queries) 1 January 24th 06 04:06 PM
Multiple excel users can open the same file and edit at the same . Jeff Howard Excel Discussion (Misc queries) 1 February 18th 05 12:19 PM
How do I stop Excel from closing the open file each time I open a. Welsin Setting up and Configuration of Excel 3 January 8th 05 11:16 PM


All times are GMT +1. The time now is 08:22 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"