- 帖子
- 4901
- 主題
- 44
- 精華
- 24
- 積分
- 4916
- 點名
- 111
- 作業系統
- Windows 7
- 軟體版本
- Office 20xx
- 閱讀權限
- 150
- 性別
- 男
- 來自
- 台北
- 註冊時間
- 2010-4-30
- 最後登錄
- 2025-5-8
               
|
回復 1# ML089
- Function MyCal(Mystr$) As Double
- Application.Volatile
- Set d = CreateObject("Scripting.Dictionary")
- ar = Array(40, 41, 42, 43, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 60, 61, 62, 91, 92, 93, 94, 95)
- For i = 0 To UBound(ar)
- d(Chr(ar(i))) = Chr(ar(i))
- Next
- For i = Len(Mystr) To 1 Step -1
- Mystr = Replace(Mystr, Mid(Mystr, i, 1), d(Mid(Mystr, i, 1)))
- Next
- MyCal = Evaluate(Mystr)
- End Function
|
|
發表於 2012-9-6 18:19
| 