您好，我只是试图使用Microsoft Access和PowerShell中的插件（命令合并PDF）合并不同的PDF文件基于复选框。我想如果他们被选中，采取他们并通过单击一个按钮将它们合并到一个PDF文档。我只是有usign另一个按钮来打开所有选中的文档，但我也想合并这些选定的文档。
我尝试了一些东西，但它不起作用。
我测试的VBS看起来像：

Function MergeSelectedPDF()

    ' Declare variables
    Dim PowerShellCmd As String
    Dim selectedPDFs As String
    Dim shellCommand As String
    Dim shellResult As Variant

    ' Initialize selectedPDFs variable
    selectedPDFs = ""

    ' Loop through your records and build a string with selected PDF file paths
    Dim rs As Recordset
    Set rs = CurrentDb.OpenRecordset("Tabulka1")
    
    Do While Not rs.EOF
        If rs![Marker] = True Then
            ' Separate file paths with spaces
            selectedPDFs = selectedPDFs & " " & rs![Odkaz]
        End If
        rs.MoveNext
    Loop
    
    rs.Close
    Set rs = Nothing

    ' Construct the PowerShell command
    PowerShellCmd = selectedPDFs & " | Merge-Pdf -OutputPath ""C:\Merged.pdf"""

    ' Execute the PowerShell command
    shellCommand = "C:\Windows\System32\WindowsPowerShell\v1.0\powershell.exe -ExecutionPolicy RemoteSigned -Command " & PowerShellCmd

    shellResult = Shell(shellCommand, vbNormalFocus)

    ' Check if an error occurred during execution
    If shellResult = 0 Then
        MsgBox "Error executing PowerShell command.", vbExclamation
    End If

End Function

字符串