+ Reply to Thread
Results 1 to 6 of 6

IsFileOpen function not working correctly

  1. #1
    Registered User
    Join Date
    06-03-2008
    Posts
    3

    IsFileOpen function not working correctly

    I'm new to this form and hope you can help me. I found a "IsFileOpen" function and everything seemed to work perfectly. However, if serveral people try to use my code you will occationially get the message "File is now available" with the Read/Write and Cancel buttons. Is there a way to prevent this from happening. I don't want the many end users to get this message. I would just like them to get my message that says it's currently in use and try later. There are many IsFileOpen functions that I have found and they all function the same way. They work fine unless several users are using at the same time.

    Any help would be most apprecitated! Thanks.

  2. #2
    Forum Contributor
    Join Date
    04-30-2008
    Posts
    105
    Post the code used in that function and the sub procedures that call it (if applicable).

  3. #3
    Registered User
    Join Date
    06-03-2008
    Posts
    3
    I took most all of the code out so you wouldn't have to go through it. With that code removed it still happens. The first message will say "A file named ...xls aready exists in the in this locations. Do you want to replace it."
    Thanks for you help!
    Please Login or Register  to view this content.
    Last edited by royUK; 06-04-2008 at 10:19 AM.

  4. #4
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200
    rjtools

    You must read the Forum Rules and in future use Ciode tags when posting VBA to the Forum. I will add them this time.
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

  5. #5
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200
    I can't test this but try changing the code by switching off alerts like this

    Please Login or Register  to view this content.

  6. #6
    Registered User
    Join Date
    06-03-2008
    Posts
    3
    Thanks, I tried it and it seems much better but I did still get the message to come up but less frequently. If you have any other suggestions I would appreciate your help!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1