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!