VBA中采用正则表达式的四则运算

采用正则表达式的四则运算:在VBA环境中，如何使用正则表达式，将正则表达式应用到四则运算中的算是分解中。 Dim r1 As RegExp Dim m1 As Match Dim mc1 As MatchCollection Dim str As String Dim sstr As String Set r = New RegExp Set r1 = New RegExp r.Global = True r1.Global = True r.Pattern = "\w*\([^()]*\)" '不支持括号嵌套 'p2 = "[\(\+\-\*\/\)]\w+" '带符号的变量或数值 'p1 = ".*?[\(\+\-\*\/\)]" '总是跟一个符号,取得第一个匹配得到函数名 p3 = "[\(\+\-\*\/\)]{0,1}\w+" '第一匹配是函数名，其他为带符号的变量或数值 p4 = "(\w+[\*\/]\w+)" '乘除运算化算，将乘除算式化成一个变量 sstr = "HArccotan(ddddd-eeeee*1000*(sqrt(-2000)-aaaa)-cos(dddd+sin(ddd*1122)))-floor(222)*20000*int(ddd)" str = sstr i = 0 action: Set mc = r.Execute(str) If mc.Count = 0 Then GoTo e