Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    The Netherlands
    Posts
    216
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Check if a file is opened

    Is there a way to check if a file is opened by someone using VBA?
    Does this also work in a network?

  2. #2
    Star Lounger
    Join Date
    Apr 2002
    Posts
    58
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Check if File is Opened

    If you use the Name statement it errors out if the file you try to rename is open. Perhaps you could use this in some manner. FileCopy also errors out if you try to copy a file that is open.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •