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(“