I (unintentionally) tried opening a Workbook from two folders with the same name (which you can't do in Excel) using a script like this:
Local $oExcel = _Excel_Open()
Local $oBook1 = _Excel_BookOpen($oExcel, "C:\1\Book.xlsx")
If @error then Exit ConsoleWrite("Failed to open book 1!" & @CRLF)
Local $oBook2 = _Excel_BookOpen($oExcel, "C:\2\Book.xlsx")
If @error then Exit ConsoleWrite("Failed to open book 2!" & @CRLF)
I was surprised to see that