Excel主文档批量更新VBA代码无响应，求修正与实现方案

需求 #

• 将同文件夹下其他Excel文件的数据更新至主Excel文档，所有文件表头完全一致
• 以第1、3、6列单元格值的组合作为唯一匹配标识符
• 匹配到的行：将其他文件中主文档没有的单元格内容，以逗号分隔合并到主文档对应单元格
• 未匹配到的行：直接将该行新增至主文档末尾

遇到的问题 #

• 不懂VBA，使用AI生成的主代码运行后无任何反应
• 现有一段可在同工作表内更新单元格内容的测试代码，不知如何整合进主代码，需要协助修正主代码以实现需求

Sub UpdateMasterDocument()
    Dim MasterWb As Workbook
    Dim MasterWs As Worksheet
    Dim OtherWb As Workbook
    Dim OtherWs As Worksheet
    Dim MasterRow As Long
    Dim OtherRow As Long
    Dim LastRowMaster As Long
    Dim LastRowOther As Long
    Dim FolderPath As String
    Dim FileName As String
    Dim MatchFound As Boolean
    Dim ColIndex As Integer
    Dim ItemIndex As Integer
    Dim MasterValue As String
    Dim OtherValue As String
    Dim MasterArray() As String
    Dim OtherArray() As String

    ' 初始化主工作簿和工作表
    Set MasterWb = ThisWorkbook
    Set MasterWs = MasterWb.Sheets(1)
    FolderPath = MasterWb.Path

    ' 遍历文件夹下所有Excel文件
    FileName = Dir(FolderPath & "\*.xls*")
    Do While FileName <> ""
        ' 跳过主文件本身，避免重复处理
        If FileName <> MasterWb.Name Then
            Set OtherWb = Workbooks.Open(FolderPath & "\" & FileName)
            Set OtherWs = OtherWb.Sheets(1)
            LastRowMaster = MasterWs.Cells(Rows.Count, 1).End(xlUp).Row
            LastRowOther = OtherWs.Cells(Rows.Count, 1).End(xlUp).Row

            ' 遍历其他文件的每一行（从第2行开始，跳过表头）
            For OtherRow = 2 To LastRowOther
                MatchFound = False
                ' 生成当前行的唯一标识符，用|分隔避免列值拼接冲突
                Dim OtherKey As String
                OtherKey = OtherWs.Cells(OtherRow, 1).Value & "|" & _
                          OtherWs.Cells(OtherRow, 3).Value & "|" & _
                          OtherWs.Cells(OtherRow, 6).Value

                ' 在主文档中查找匹配的行
                For MasterRow = 2 To LastRowMaster
                    Dim MasterKey As String
                    MasterKey = MasterWs.Cells(MasterRow, 1).Value & "|" & _
                              MasterWs.Cells(MasterRow, 3).Value & "|" & _
                              MasterWs.Cells(MasterRow, 6).Value

                    If MasterKey = OtherKey Then
                        MatchFound = True
                        ' 合并非标识符列的内容
                        For ColIndex = 1 To OtherWs.Cells(OtherRow, Columns.Count).End(xlToLeft).Column
                            ' 跳过标识符列（1、3、6）
                            If ColIndex <> 1 And ColIndex <> 3 And ColIndex <> 6 Then
                                MasterValue = Trim(MasterWs.Cells(MasterRow, ColIndex).Value)
                                OtherValue = Trim(OtherWs.Cells(OtherRow, ColIndex).Value)

                                ' 处理空值情况，避免无效拼接
                                If OtherValue = "" Then GoTo NextColumn
                                If MasterValue = "" Then
                                    MasterWs.Cells(MasterRow, ColIndex).Value = OtherValue
                                    GoTo NextColumn
                                End If

                                ' 拆分内容为数组，检查并添加主文档没有的内容
                                MasterArray = Split(MasterValue, ", ")
                                OtherArray = Split(OtherValue, ", ")
                                For ItemIndex = LBound(OtherArray) To UBound(OtherArray)
                                    If Not IsInArray(Trim(OtherArray(ItemIndex)), MasterArray) Then
                                        MasterWs.Cells(MasterRow, ColIndex).Value = MasterWs.Cells(MasterRow, ColIndex).Value & ", " & Trim(OtherArray(ItemIndex))
                                    End If
                                Next ItemIndex
                            End If
NextColumn:
                        Next ColIndex
                        Exit For
                    End If
                Next MasterRow

                ' 未匹配到则新增行到主文档末尾
                If Not MatchFound Then
                    LastRowMaster = LastRowMaster + 1
                    OtherWs.Rows(OtherRow).Copy Destination:=MasterWs.Rows(LastRowMaster)
                End If
            Next OtherRow

            OtherWb.Close SaveChanges:=False
        End If
        FileName = Dir
    Loop
End Sub

Function IsInArray(stringToBeFound As String, arr As Variant) As Boolean
    Dim i As Variant
    For Each i In arr
        If Trim(CStr(i)) = stringToBeFound Then
            IsInArray = True
            Exit Function
        End If
    Next i
    IsInArray = False
End Function

• 修正路径错误：原代码中MyFolder未定义，替换为实际的主文件路径FolderPath，同时添加判断跳过主文件本身，避免重复处理
• 调整遍历逻辑：改为遍历其他文件的行去匹配主文档，确保所有其他文件的行都能被检查，解决原逻辑漏加未匹配行的问题
• 优化标识符生成：用|分隔三列值作为唯一键，避免因列值本身包含连接符导致的匹配错误
• 完善内容合并：处理空值情况，避免出现开头逗号；添加Trim去除内容前后空格，确保匹配准确
• 保留核心匹配逻辑：沿用IsInArray函数判断内容是否已存在，确保只新增主文档没有的内容

内容的提问来源于stack exchange，提问作者Gertrude Gertjan