Excel VBA: Workbooks.Open returns the wrong object

vba open workbook from path
workbooks.open vba
excel vba open workbook with variable name
vba set workbook without opening
vba code to open excel file from folder
vba code to browse and open an excel file
workbooks.open updatelinks
workbooks.open read only