Hi
you're right (to hot inside the office probably). Didn't
read that the files are opened 'read-only'. So the OP
should try your suggestion

P.S.: Still I don't think this is a good design :-)

-----Original Message-----
"Frank abel" wrote:

Hi
I doubt this is possible (prevented by the Operating
System). If a file is opened by another user this can't
be
over-written (in addition what should happen for the
user
who has opened this file: automatic closing of Excel or
automatic replacing?).

So AFAIK this is not Excel specific but restricted by
the
OS
Some ideas for a workaround:
-maybe use a shared Excel file (and live with the
restrictions of this feature)
- use a different type of application (e.g. database)

Frank.. frankly i think you're confused !

if any program (including Excel) opens a file as readonly
it IS readonly.. and any program or user can delete it
(if it has permission from the filesystem in that
directory)

Test:
new workbook
save as ro.xls
close
open readonly ro.xls (in xlXP dropdown the open button)
(in xl97 use option button
(topright)

in explorer = delete the file.



keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool
.