How to determine a file is still open?

[mkuan]

I want to write to a file that I know the name and location. I get "Permission denied" error message if the file is opened by some other app while I try to write to it.

My question: Is there a way to determine if a file has an "Open" state using VB?

TIA.

 

[johnwm]

It's a trappable error - just trap it and deal appropriately. See faq222-1694 and faq222-4063

________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first

'If we're supposed to work in Hex, why have we only got A fingers?'

http://www.essexsteam.co.uk

for steam enthusiasts

 

[HarleyQuinn]

Could you just trap for the "Permission Denied" error and take it from there with the error handling???

Harleyquinn

---------------------------------
For tsunami relief donations

 

[HarleyQuinn]

Sorry John, must have been typing at the same time.

Harleyquinn

---------------------------------
For tsunami relief donations

 

[johnwm]

As long as it solves the problem.....

________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first

'If we're supposed to work in Hex, why have we only got A fingers?'

http://www.essexsteam.co.uk

for steam enthusiasts