Thanatos

Is there a way i can check to see if a file is currently in use prior to opening it? I want to avoid that runtime error.

ALEX_0077

(If you mean 'an open file that your program opened...)

Sure!

(Of course i was going to say the obvious. )

In your code, always make sure to keep track of open files so that you can close them when your program stops. I know this isn't the prettiest way, but it is simple.

Example:

'IN your code you may have a function that opens any file like this:

Private Function OpenFile(Byval strFileName as String) as boolean

Dim Y
Y = FreeFile

Open strFileName for Input as Y

'Do whatever
Close Y

End Function

'-or-


Private Function OpenFile(byval strFileName as String) as boolean

Open strFileName for Output as #1
'Do whatever
Close #1
End Function

Thanatos

actually i mean a file that might currently be in use by another program

ALEX_0077

Oh.

In that case, maybe this will help you. its a code at vbDiamond
that was written by Jerry Barnett

Click here to see example stuff on checking to see if file is open or something

PS. Hope this helps.