完整方法: 首先在工程中添加一个Class Module,然后在里面加入一句代码: Public k1 As Integer 然后在工程中加入Microsoft Script Control控件,在窗体中加入一个Microsoft Script Control控件和一个Button: Private Sub Command1_Click() Dim a(1) Dim shar As New Class1
ScriptControl1.AddObject "sh", shar ScriptControl1.AddCode "Function Main(x)" & vbCrLf & "kk=3+2*1" & vbCrLf & "sh.k1 = kk " & vbCrLf & "End Function" ScriptControl1.Run "main", a Debug.Print shar.k1 End Sub点击Button1得到结果
数据结构书
2、方在sql server 中
declare @sql varchar(100)
select @sql='select 3+2*1'
exec(@sql)
Dim s As String, Scpt As New ScriptControl
Scpt.Language = "VBScript"
MsgBox Scpt.Eval("3+2*1")
End Sub
http://rookscape.com/vbgaming/tutBQ.php
首先在工程中添加一个Class Module,然后在里面加入一句代码:
Public k1 As Integer
然后在工程中加入Microsoft Script Control控件,在窗体中加入一个Microsoft Script Control控件和一个Button:
Private Sub Command1_Click()
Dim a(1)
Dim shar As New Class1
ScriptControl1.AddObject "sh", shar
ScriptControl1.AddCode "Function Main(x)" & vbCrLf & "kk=3+2*1" & vbCrLf & "sh.k1 = kk " & vbCrLf & "End Function" ScriptControl1.Run "main", a
Debug.Print shar.k1
End Sub点击Button1得到结果