VBA

Moderators: PavlinII
Number of threads: 1673
Number of posts: 3078

This Forum Only
Post New Thread
Single Post View       Linear View       Threaded View      f

Report
Check if a File is Locked Posted by KhalilDutch on 16 Dec 2004 at 8:50 AM
Hello all,

I've got a programm running that retrieves information from a file.
After all the information is gathered the file (among other things) is placed in another directory.

I'm now encountering small problems while moving the file(s). The file can't be moved because of the fact the file is locked by another process (which creates this file).

Is there a way in VB to determ if a file has a lock or not?
I've looked at the Getattr function, but that doesn't return what I need.

If anybody can point me in the right direction....

Thanks in advance.

--KhalilDutch--
___________________________
If ... Then
...
Else
...
Whatever....
Report
Re: Check if a File is Locked Posted by PavlinII on 27 Jan 2005 at 12:05 PM
: Hello all,
:
: I've got a programm running that retrieves information from a file.
: After all the information is gathered the file (among other things) is placed in another directory.
:
: I'm now encountering small problems while moving the file(s). The file can't be moved because of the fact the file is locked by another process (which creates this file).
:
: Is there a way in VB to determ if a file has a lock or not?
: I've looked at the Getattr function, but that doesn't return what I need.
:
: If anybody can point me in the right direction....
:
: Thanks in advance.
:
: --KhalilDutch--
: ___________________________
: If ... Then
: ...
: Else
: ...
: Whatever....
:


Hi, try
Private Function IsLocked() as boolean
  On Error Goto FileIsLocked
  #iFile=FreeFile()
  Open "C:\Path\file.ext" For Output Lock Read Lock Write as #iFile
  Close #iFile
  IsLocked=True
  Exit Function
FileIsLocked:
  Exit Function
End Function

If the file is locked, Open will cause error, if not, True is returned

..this should work..


Pavlin II[/size]

Don't take life too seriously anyway you won't escape alive from it!





 

Recent Jobs

Official Programmer's Heaven Blogs
Web Hosting | Browser and Social Games | Gadgets

Popular resources on Programmersheaven.com
Assembly | Basic | C | C# | C++ | Delphi | Flash | Java | JavaScript | Pascal | Perl | PHP | Python | Ruby | Visual Basic
© Copyright 2011 Programmersheaven.com - All rights reserved.
Reproduction in whole or in part, in any form or medium without express written permission is prohibited.
Violators of this policy may be subject to legal action. Please read our Terms Of Use and Privacy Statement for more information.
Operated by CommunityHeaven, a BootstrapLabs company.