Difference between ERROR and ERROR$ functions 1

[vassoft]

hello
I am having doubt.
What is the difference between Error() and Error$()
functions.

Both are error functions returning same values.

I need to know What is the significance of "$".

I am very thankful in this regard

Vasu

 

[sunaj]

Same same. The "$" indicates that the function returns a string. Error always returns string. This is not the case for other functions e.g. Mid returns a variant whereas Mid$ returns a string.

Sunaj
'The gap between theory and practice is not as wide in theory as it is in practice'

 

[CCLINT]

Error simulates the occurrence of an error, and returns the description error (as a Variant) that occured and is only supported for backward compatibility.

Debug.Print Error(13)
Will just print the error description of error number 13.

Debug.Print Error
Will do nothing

Error(13)
Will raise an error

Error$ only returns the description of a error number as a string and corresponds to the Description property of the Err object.

Debug.Print Error$(13)
Will just print the error description of error number 13.

It is also obsolete.

Use the Err object instead. *******************************************************
General remarks:
If this post contains any suggestions for the use or distribution of code, components or files of any sort, it is still your responsibility to assure that you have the proper license and distribution rights to do so!