如何通过Interop将函数调用作为参数传递给Excel宏？

using Excel = Microsoft.Office.Interop.Excel;

Excel.Application excelApp = new Excel.Application();

Excel.Workbook workbook = excelApp.Workbooks.Open("YourExcelFile.xlsx");
Excel.Worksheet worksheet = workbook.Worksheets["Sheet1"];

object[] functionParams = new object[] { "FunctionName", "Parameter1", "Parameter2" };

excelApp.Run("YourMacroName", functionParams);

Sub YourMacroName(functionParams As Variant)
    Dim functionName As String
    Dim parameter1 As String
    Dim parameter2 As String
    
    functionName = functionParams(0)
    parameter1 = functionParams(1)
    parameter2 = functionParams(2)
    
    ' 在这里执行你的逻辑，调用外部函数并使用参数值
End Sub