kicking people out of write access in spreadsheets

stickboy

Board Regular
Joined
Jun 23, 2002
Messages
84
Afternoon all,

I have a file on a network drive that is accessible by a number of users.

However, at a certain time of the day (say 8am) I want to be able to go into the file and get the latest info out.

However, if someone is in the file at the same time my version is read-only. This causes a problem because I want to clear the file out and save it on top for the next day.

Is there any way to open the file - check if it is readonly - and if it is, then kick the other person out, and make my version read/write?

Thanks
Stuart
 

Excel Facts

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.

johnpdavey

Board Regular
Joined
May 30, 2002
Messages
88
sorry i dont have the answer but i would like to know if there is a way as well, or at least a way to send a message to whoever has the file open asking them to log out.
 

Forum statistics

Threads
1,144,765
Messages
5,726,173
Members
422,659
Latest member
RGP268

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top