+ Reply to Thread
Results 1 to 2 of 2

Ripping out my hair please help (not much hair left)

  1. #1
    Registered User
    Join Date
    08-25-2004
    Posts
    82

    Ripping out my hair please help (not much hair left)

    Hello everyone, thank you for taking the time to help me out with my problem. I have a program that deletes the old forms and imports the new ones, problem is every once in a while it cant import a file because it says the file is in use. But the last person to access the file did so 30 minutes ago. How is this possible. Is it leaving the file open in system memory ? here is the code that i am using to delete and import the file



    Sub DeleteModules()
    On Error Resume Next
    Dim VBComp As VBComponent

    Set VBComp = ThisWorkbook.VBProject.VBComponents("FormHelp")
    ThisWorkbook.VBProject.VBComponents.Remove VBComp

    Set VBComp = ThisWorkbook.VBProject.VBComponents("frmMenu")
    ThisWorkbook.VBProject.VBComponents.Remove VBComp

    Sub ImportModules()
    Dim FName As String

    serverconnection = "C:\timesheet\"
    cPath = serverconnection

    Filename = "FormHelp.frm"
    FName = cPath & Filename
    ThisWorkbook.VBProject.VBComponents.Import FName
    Filename = "frmMenu.frm"
    FName = cPath & Filename
    ThisWorkbook.VBProject.VBComponents.Import FName
    End Sub

    any help is appriated

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

+ 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