Results 1 to 5 of 5
  1. #1
    5 Star Lounger
    Join Date
    Nov 2001
    Location
    Jerusalem, Israel
    Posts
    708
    Thanks
    0
    Thanked 1 Time in 1 Post

    Dll stops working (2003)

    I have a dll that has worked in my code for the past two years. All of a sudden I got the following message: Activex Component cannot create object.
    I copied the dll fresh from the download site in case the file was corrupt, but nothing goes. I created a whole new database and created a module to test this dll also no go.
    The dll is referenced in the database. I tried unchecking and rechecking it
    Any ideas on why a dll should go bad like this?
    Attached is the dll if you want to try it
    thanks


    My code is:
    Public Function fGetWords(varNumber As Variant, Optional blDollar As Boolean) As Variant
    On Error GoTo Err_fGetWords

    Dim vResult As Variant

    Dim MyDll As New ConvertNo2Words.GetWords
    Dim strNumber As String

    If varNumber > 999999.99 Then
    Dim StrAmount2 As String
    StrAmount2 = InputBox("
    Attached Files Attached Files

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Dll stops working (2003)

    It works for me - although the result is nonsense, probably since I don't have Hebrew installed. I'll try to look at it later.

  3. #3
    5 Star Lounger
    Join Date
    Nov 2001
    Location
    Jerusalem, Israel
    Posts
    708
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Dll stops working (2003)

    I installed office 2007 and have opened this database also in 2007. I wonder if that corrupt the dll in some way, although I did download a new copy.
    Could just the fact that office 2007 is installed affect the way dll's work on the whole system?

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Dll stops working (2003)

    Installing an Office version should not corrupt a non-Office DLL, or influence the way non-Office DLLs work.
    You might try registering the DLL:
    - Select Start | Run...
    - Type regsvr32 "c:folder1folder2ConvertNo2Words.dll" (substitute the correct path).
    - Click OK or press Enter.

  5. #5
    5 Star Lounger
    Join Date
    Nov 2001
    Location
    Jerusalem, Israel
    Posts
    708
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Dll stops working (2003)

    As usual your advice was 100% on target!
    Thanks so much

Posting Permissions

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