excel - 将参数数组传递给需要参数数组的函数

Question

在 excel-vba 中，如何将参数数组传递给需要相同参数数组的函数？我一直在环顾四周，但似乎找不到这个特定问题的任何答案

我的代码如下所示:

Sub test()
    GetRefData "SPX Index", "PX_LAST", "PX_VOLUME", "PE_RATIO", "PX_TO_CASH_FLOW"
End Sub

Public Function GetRefData(security As String, ParamArray fields() As Variant) As String
    Debug.Print fields(0) // returns "PX_LAST"
    SendReq security, fields
End Function

Sub SendReq(security, ParamArray fields() As Variant)
    Debug.Print fields(0) // returns type mismatch
End Sub

Answer 1

查找后the article Tim posted ，解决方案是参数数组在作为参数传递时必须访问更深一层，即:

Sub SendReq(security, ParamArray fields() As Variant)
    Debug.Print fields(0)(0)
End Sub