505.369.1650 [email protected]

Determine if a File is Open

Use this VBA function to determine if a file is already open.  For example, before attempting to import an Excel file into a Microsoft Access database, you can call this function, and if the file is open, notify the user that they need to close the Excel file first. ...