MATLAB BUILDER EX 1 Guía de usuario descargar pdf (Pagina 30)

2 Programming with MATLAB Builder for Excel

Function foo(x1 As Variant, x2 As Variant) As Variant

Dim aClass As Object

Dim y As Variant

On Error Goto Handle_Error

aClass = CreateObject("mycomponent.myclass.1_0")

Call aClass.foo(1,y,x1,x2)

foo = y

Exit Function

Handle_Error:

foo = Err.Description

End Function

The second example rewrites the same function as a subroutine and uses

Excel ranges for input and output.

Sub foo(Rout As Range, Rin1 As Range, Rin2 As Range)

Dim aClass As Object

On Error Goto Handle_Error

aClass = CreateObject("mycomponent.myclass.1_0")

Call aClass.foo(1,Rout,Rin1,Rin2)

Exit Sub

Handle_Error:

MsgBox(Err.Description)

End Sub

2-10

1 2 ... 25 26 27 28 29 30 31 32 33 34 35 ... 163 164

Sin comentarios

MATLAB BUILDER EX 1 Guía de usuario Pagina 30