Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Delete/Close Excel file that is kept OPEN
Hi,
We have excel reports in shared server location, which the users have access to open directly from that location. Every week these reports will be replaced with new one. We are experiencing the "Permission denied" error when the MS Access application tries to overwrite them with new reports. This error occurs because some users leave the report OEPN even after using it. We have no idea who has kept the file OPEN. My requirement is to close or delete the instance of file when the file is OPEN, so that this error will not occur at runtime. Also is there a way to identify whether a file is kept OPEN or not, if we know the filename? Rgds, Jafer |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I open a file downloading in MS Excel | Excel Worksheet Functions | |||
One file in Excel will not open. | Excel Discussion (Misc queries) | |||
Application hang when open a schema file in Excel | Excel Discussion (Misc queries) | |||
Why Excel file doesn't open by double click. | Excel Discussion (Misc queries) | |||
How Do I open an excel file without Excel Viewer support | Excel Discussion (Misc queries) |