Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
File Locked or Not
Is there a way to have a list of excel files and use some sort of code to
tell if the file is currently in use. Example: Column 1 (Excel Path) Column 2 (Availability) Path\ExcelFileName.xls Currently In Use Path\ExcelFileName2.xls Available The reason for this is that I use an Excel Macro to execute an Access Macro and if the files are in use, my code fails due to the file being "Read-Only." If I know ahead of time who is using the file, I can proactively call the individual and then I can simply run the Macro with no issues. Let me know if you Need anymore details! Thanks in Advanced! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
disc full, saved to temp. file | Excel Discussion (Misc queries) | |||
file will not open | Excel Discussion (Misc queries) | |||
file is locked does not appear in Excel if file already open by an | New Users to Excel | |||
Filling Text from Another File | Excel Worksheet Functions | |||
Locked out of default file location | Excel Discussion (Misc queries) |