使用Excel VBA将文件夹和变量传递给下一个宏

Sub NextMacro(folderPath As String, myVariable As Variant)
    ' 在这里编写你的代码，可以使用传递的文件夹路径和变量
End Sub

Sub MainMacro()
    Dim folderPath As String
    Dim myVariable As Variant
    
    ' 设置文件夹路径和变量的值
    folderPath = "C:\Folder\Path"
    myVariable = "Hello, World!"
    
    ' 调用下一个宏并传递文件夹路径和变量
    Call NextMacro(folderPath, myVariable)
End Sub