I have a piece of code in a class in a DLL...

Public Function Test() As String

On Error GoTo errHandler

Test = "This is Library DBGateway Class DynamicSQL Function Test"

Exit Function

errHandler:

Set mErr = Err
Err.Raise vbObjectError + mErr.Number, _
mErr.Source & ":DynamicSQL:Test", _
mErr.Description
Resume Next

End Function

When running locally as part of a project group, the function returns the expected string. When compiled and referenced from another project, the function returns nothing, produces no error message, and does not time out. It seems to be running normally, but there is no string.

If anyone knows how to get it to return the string, or at least how to get it to tell me why it will not return the string, it would be much appreciated. It's driving me to drink.

Thanks.