从.NET中的VBA函数访问返回值?

是否尝试将函数移到Excel中的常规模块(而不是工作表模块)?

一个简单的例子:

电子表格.xlsm 有 Module1 包含:

Public Function test() As String
  test = "hello 1234"
End Function

objExcel

Dim result = objExcel.Run("Module1.test")
MsgBox(result)

... 生产 hello 1234

因为我最初是用 ? module1.test() (成功) objExcel.Run("Module1.test()") 去工作-但我犯了个错误: Cannot run the macro .... The macro may not be available in this workbook or all macros may be disabled.

尝试将乘法函数修改为如下代码:

Public Function Multiply(a As Double, b As Double) As Double
    return a * b
End Function