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!
|