+ Reply to Thread
Results 1 to 2 of 2

Open .frm without locking it (URGENT!!)

Hybrid View

greenfalcon Open .frm without locking it... 03-14-2005, 03:35 PM
greenfalcon any help??? thanks 03-17-2005, 08:44 PM
  1. #1
    Registered User
    Join Date
    08-25-2004
    Posts
    82

    Open .frm without locking it (URGENT!!)

    Filename = "FormHelp.frm"
    FName = cPath & Filename


    ThisWorkbook.VBProject.VBComponents.Import FName

    Even though this is open for only a few seconds to import the file located on a server, it is still possible that it is in use while someone else opens up a new spreadsheet, is there a way either to have it not locked, so that multiple people could access the file at once. OR option two,

    I was thinking about looping, if on error, put in a wait delay, and check after 5 seconds and loop that a few times until the file becomes available.

    Any ideas? Code really helps thanks.

  2. #2
    Registered User
    Join Date
    08-25-2004
    Posts
    82
    any help???

    thanks

+ 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