Menu

Open-Save Strategy

Search this Thread

Prev

Previous Post

Next Post

Next

#3

Report Post

Posted to microsoft.public.excel.programming

Nigel[_2_] Nigel[_2_] is offline

Nigel[_2_] is offline

external usenet poster

Posts: 735

Default

Open-Save Strategy

Great tip Dave, thanks very much.

--

Regards,
Nigel

"Dave Peterson" wrote in message
...
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 With Quote

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
Strategy Needed	kleivakat	Excel Discussion (Misc queries)	2	March 7th 06 09:09 PM
Custom Hotkey Strategy	Sprinks	Excel Programming	2	December 29th 05 08:27 PM
Freeze IDE or other strategy ???	Greg Wilson	Excel Programming	2	June 17th 05 06:05 AM
Workbook Switching Strategy	Nigel	Excel Programming	6	May 5th 05 06:24 PM
Strategy Query	Chuckles123[_73_]	Excel Programming	0	November 24th 04 04:22 AM

All times are GMT +1. The time now is 02:43 PM.

About Us

"It's about Microsoft Excel"

Contact Us ExcelBanter forum home Privacy Statement