7,785
社区成员




'该函数使用的是前期绑定
Function result(ByVal X1 As String) As Double
On Error GoTo err
Dim obj As New MSScriptControl.ScriptControl
obj.Language = "vbscript"
result = Round(obj.Eval(X1), 2)
Set obj = Nothing
Exit Function
err:
MsgBox err.Description
End Function
'该函数使用的是后期绑定
Function result2(ByVal X1 As String) As Double
On Error GoTo err
Dim obj As Object
Set obj = CreateObject("MSScriptControl.ScriptControl")
obj.Language = "vbscript"
result2 = Round(obj.Eval(X1), 2)
Set obj = Nothing
Exit Function
err:
MsgBox err.Description
End Function