CVErr, Excel and VB .NET

[Howard Kaikow]

Many Excel macros/add-ins rely on the use of the VB/VBA CVErr function.

Alas, VB .NET does not support the CVErr function.

Does Excel 2003, Office 2003 or Visual Studio Tools for Office provide a
substitute?

 

[Keith Willshaw]

Many Excel macros/add-ins rely on the use of the VB/VBA CVErr function.

Alas, VB .NET does not support the CVErr function.

Does Excel 2003, Office 2003 or Visual Studio Tools for Office provide a
substitute?

But in .net you can achieve the same functionallity
by using the exception handling routines it does support

In VB6 you'd call a VB error code as follows

Function CalculateDouble(Number)
If IsNumeric(Number) Then
CalculateDouble = Number * 2 ' Return result.
Else
CalculateDouble = CVErr(2001) ' Return a user-defined error
End If ' number.
End Function


In .net you'd throw an exception to do the same thing
with the call

Throw new InvalidOperationException("Invalid Input to Function")

Keith

 

[Howard Kaikow]

Yes, I recall, perhaps incorrectly, that special error codes in Excel, such
as xlErrValue, required use of a Variant.