参考:
http://www.excelpx.com/thread-371957-1-1.html
Sub test()
Dim ID, x
'例1:调用lcm(),最小公倍数
ID = ExecuteExcel4Macro("REGISTER.ID(""" & Application.LibraryPath & "\Analysis\ANALYS32.XLL"",""lcm"")")
x = Run(ID, 36, 90, 72) 'x= 360
Debug.Print x
'例2:调用hex2bin(),十六进制转二进制
ID = ExecuteExcel4Macro("REGISTER.ID(""" & Application.LibraryPath & "\Analysis\ANALYS32.XLL"",""hex2bin"")")
x = Run(ID, 12) '十六进制12表示十进制的18,也就是二进制的10010
Debug.Print x
End Sub