Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Open-Save Strategy
Hi All
I have the following concept in mind and I am looking for the most effective strategy for a solution. On a network server I have an application workbook that many different users can open and interact with simultaneously. When any user completes their usage of the file it just closes (no save). The problem is that I cannot avoid users receiving the message that the file is already in use, if another user has it open already. My thoughts so far are as follows.... 1. Any user opens remote workbook 2. This workbook is 'saved as' a temporary.xls file locally in a temp space on their local disc, releasing the server file. 3. Additional users can now open the server version (step 1 above) and the cycle repeats for each user. No user receives the file already is use message, unless it happens to coincide with the open-save process of step 1 and 2 - likelihood of this low. Question: Is the viable and presumably I can use workbook events to control the save and rename process. Thanks ------------ Nigel |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Open-Save Strategy
If the users aren't saving the file, you could use windows explorer to mark it
readonly. Then any number of users could open the file, but no one could save it as the same name. You can also provide a password to modify (not open). File|SaveAs|Tools|General Options (If you wanted the ability to open to modify it.) Nigel wrote: Hi All I have the following concept in mind and I am looking for the most effective strategy for a solution. On a network server I have an application workbook that many different users can open and interact with simultaneously. When any user completes their usage of the file it just closes (no save). The problem is that I cannot avoid users receiving the message that the file is already in use, if another user has it open already. My thoughts so far are as follows.... 1. Any user opens remote workbook 2. This workbook is 'saved as' a temporary.xls file locally in a temp space on their local disc, releasing the server file. 3. Additional users can now open the server version (step 1 above) and the cycle repeats for each user. No user receives the file already is use message, unless it happens to coincide with the open-save process of step 1 and 2 - likelihood of this low. Question: Is the viable and presumably I can use workbook events to control the save and rename process. Thanks ------------ Nigel -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Strategy Needed | Excel Discussion (Misc queries) | |||
Custom Hotkey Strategy | Excel Programming | |||
Freeze IDE or other strategy ??? | Excel Programming | |||
Workbook Switching Strategy | Excel Programming | |||
Strategy Query | Excel Programming |