Question:
How can I check to see if a file is in use/open?
Answer:
An easy way to do this is to attempt to open the file for writing. If you get an error and have verified that the file exists, the file is most likely already open. You can use the On Error statement to set an error trap for error that will occur if you attempt to open a file that is already open.