Excel VBA -如何区分同一循环中具有相同路径的两个WorkBooks

Dim wb1 As Workbook
Dim wb2 As Workbook

Set wb1 = Workbooks("Workbook1.xlsx")
Set wb2 = Workbooks("Workbook2.xlsx")

If wb1.Name = wb2.Name Then
    ' 两个Workbook具有相同的名称
Else
    ' 两个Workbook具有不同的名称
End If

Dim wb1 As Workbook
Dim wb2 As Workbook

Set wb1 = Workbooks.Open("C:\Path\Workbook1.xlsx")
Set wb2 = Workbooks.Open("C:\Path\Workbook2.xlsx")

If wb1.FullName = wb2.FullName Then
    ' 两个Workbook具有相同的完整路径和文件名
Else
    ' 两个Workbook具有不同的完整路径和文件名
End If

Dim wb1 As Workbook
Dim wb2 As Workbook

Set wb1 = Workbooks(1)
Set wb2 = Workbooks(2)

If wb1.Index = wb2.Index Then
    ' 两个Workbook具有相同的索引位置
Else
    ' 两个Workbook具有不同的索引位置
End If