FileSystemObject and open files

[jeffmoore]

Hi,
I need to determine if a file (log file) is open. If I open the log file in excel (while it is in use), excel lets me know that it is read only. Is there some way to use the FileSystemObject to determine this. I have look at the attributes prop but it doesnt appear to have that functionality.
What I'm trying to do is to poll a directory and check and see if the log file is closed. If it is, I'm going to use code to import the data in to access, then delete the file.
TIA
Jeff

 

[jbpez]

Try opening the file while already open and get the error number. Then create an error handler for that error number that tells you that the file is open.

John Borges

 

[jeffmoore]

Thanks that works great